Commit d6768d8

使用 `with_column_width()` 和 `with_column_hidden()` 可按最终 dynamic/Serde header name 配置每列的固定布局。Explicit width 是 AutoWidth 的起始最小值；hidden 状态不会删除数据，隐藏列仍可查询。

| Per-column width/hidden | `WriteOptions::with_column_width()` / `with_column_hidden()` | Final header-name mapping; explicit width seeds AutoWidth |

Writer tests generate temporary workbooks through `MiniExcel::save_as*()` and read them back through `MiniExcel::query*()`, covering dynamic and typed values, dates, multiple worksheets, visible/hidden/very-hidden states, active-sheet selection, row counts, empty schemas, default/custom/disabled freeze panes, header/headerless/typed AutoFilter ranges, right-to-left views, bounded fixed AutoWidth output, explicit/hidden column layout, ordinary body wrapping with formatted-value exclusions, body alignment composed with wrapping and number formats, default/custom header styles, default/minimal cell style modes, explicit path overwrite behavior, and worksheet-name validation. Template tests cover scalar and mixed text, native numbers and booleans, XML escaping, formula-injection protection, missing-variable policy, empty and populated arrays, multiple sheets, style retention, path overwrite, and byte workflows. The WASM adapter has native unit tests, while Browser Lab Playwright tests cover generated-workbook rendering, query controls, inclusive end ranges, and desktop/mobile viewports.

| 每列 width/hidden | `WriteOptions::with_column_width()` / `with_column_hidden()` | 按最终 header name 映射；explicit width 作为 AutoWidth 起点 |

Writer test 通过 `MiniExcel::save_as*()` 生成临时 workbook，并使用 `MiniExcel::query*()` 回读，覆盖动态和类型化 value、date、多工作表、visible/hidden/very-hidden 状态、active sheet 选择、行数、空 schema、默认/自定义/禁用冻结窗格、header/headerless/typed AutoFilter 范围、从右到左 view、有界固定 AutoWidth 输出、explicit/hidden column layout、普通 body 换行及 formatted-value 排除、body 对齐与换行/number format 组合、默认/自定义 header style、默认/最小 cell style 模式、显式 path 覆盖行为和 worksheet name 验证。模板测试覆盖标量与混合文本、原生 number/boolean、XML 转义、公式注入防护、缺失变量策略、空数组与非空数组、多工作表、样式保留、path 覆盖和 byte 工作流。WASM adapter 有原生 unit test，Browser Lab Playwright test 则覆盖生成 workbook 的渲染、query 控件、包含端点的结束 range，以及桌面/移动 viewport。

| Attribute-based mapping | Partial | Column index/name attributes, localized headers, formula metadata, custom dynamic formatters, field mapping, and dynamic column ordering/filtering remain. Serde covers rename, alias, defaults, skips, options, and custom serializers; `WriteOptions` covers width/hidden layout by final header name. |

| 特性式字段映射 | 部分实现 | 仍缺列索引/名称特性、本地化表头、公式元数据、自定义动态格式器、字段映射，以及动态列排序/过滤。Serde 可覆盖重命名、别名、默认值、跳过、可选值和自定义序列化；`WriteOptions` 可按最终 header name 配置 width/hidden layout。 |

column_widths: IndexMap<String, f64>,

hidden_columns: IndexMap<String, bool>,

#[must_use]

pub fn with_column_width(mut self, field_name: impl Into<String>, width: f64) -> Self {

self.column_widths.insert(field_name.into(), width);

self

}

#[must_use]

pub fn with_column_hidden(mut self, field_name: impl Into<String>, hidden: bool) -> Self {

self.hidden_columns.insert(field_name.into(), hidden);

self

}

#[must_use]

pub(crate) fn column_width(&self, field_name: &str) -> Option<f64> {

self.column_widths.get(field_name).copied()

}

#[must_use]

pub(crate) fn column_widths(&self) -> &IndexMap<String, f64> {

&self.column_widths

}

#[must_use]

pub(crate) fn column_hidden(&self, field_name: &str) -> bool {

self.hidden_columns.get(field_name).copied().unwrap_or(false)

}

column_widths: IndexMap::new(),

hidden_columns: IndexMap::new(),

let mut widths = AutoWidthCollector::new(schema, options)?;

apply_column_layout(&mut worksheet, schema, options)?;

let field_names = serialized_field_names(first)?;

let custom_headers = serialized_field_options(&field_names, options);

let mut widths = AutoWidthCollector::new(&field_names, options)?;

apply_column_layout(&mut worksheet, &field_names, options)?;

fn new(columns: &[String], options: &WriteOptions) -> Result<Self> {

widths: columns

.iter()

.map(|column| options.column_width(column).unwrap_or(options.min_width()) + PADDING)

.collect(),

fn serialized_field_names<T>(first: &T) -> Result<Vec<String>>

Ok(fields.keys().cloned().collect())

fn serialized_field_options(

fields: &[String],

options: &WriteOptions,

) -> Vec<CustomSerializeField> {

fields

.iter()

.collect()

fn apply_column_layout(

worksheet: &mut Worksheet,

columns: &[String],

options: &WriteOptions,

) -> Result<()> {

validate_column_widths(options)?;

const PADDING: f64 = 5.0 / 7.0;

for (index, column) in columns.iter().enumerate() {

if !options.auto_width() {

if let Some(width) = options

.column_width(column)

.or_else(|| options.column_hidden(column).then_some(options.min_width()))

{

let pixels = ((width + PADDING) * 7.0).round() as u32;

worksheet.set_column_width_pixels(index as u16, pixels)?;

}

}

if options.column_hidden(column) {

worksheet.set_column_hidden(index as u16)?;

}

}

Ok(())

fn validate_column_widths(options: &WriteOptions) -> Result<()> {

if options.column_widths().values().any(|width| !width.is_finite() || *width < 0.0) {

return Err(Error::invalid_write_options("column widths must be finite and non-negative"));

}

Ok(())