以下是基于您提供的内容整理的完整示例demo，先展示内容中的示例，然后提供综合示例：

内容中提供的示例回顾

1. 创建简单Excel文件示例

use xlsxwriter::*;

fn main() -> Result<(), XlsxError> {
    let workbook = Workbook::new("simple.xlsx")?;
    let mut worksheet = workbook.add_worksheet(None)?;
    
    worksheet.write_string(0, 0, "Hello", None)?;
    worksheet.write_number(1, 0, 123.456, None)?;
    worksheet.write_boolean(2, 0, true, None)?;
    
    workbook.close()?;
    Ok(())
}

1. 使用单元格格式示例

use xlsxwriter::*;

fn main() -> Result<(), XlsxError> {
    let workbook = Workbook::new("formats.xlsx")?;
    let mut worksheet = workbook.add_worksheet(None)?;
    
    let bold_format = Format::new()
        .set_bold()
        .set_font_color(FormatColor::Red);
    
    let money_format = Format::new()
        .set_num_format("$#,##0.00");
    
    worksheet.write_string(0, 0, "Item", Some(&bold_format))?;
    worksheet.write_string(0, 1, "Cost", Some(&bold_format))?;
    
    worksheet.write_string(1, 0, "Book", None)?;
    worksheet.write_number(1, 1, 15.95, Some(&money_format))?;
    
    workbook.close()?;
    Ok(())
}

综合完整示例

use xlsxwriter::*;

fn main() -> Result<(), XlsxError> {
    // 1. 创建工作簿和工作表
    let workbook = Workbook::new("demo.xlsx")?;
    let mut worksheet = workbook.add_worksheet(Some("销售数据"))?;
    
    // 2. 设置列宽
    worksheet.set_column(0, 0, 15.0, None)?; // A列宽度15
    worksheet.set_column(1, 3, 10.0, None)?; // B-D列宽度10

    // 3. 定义格式
    let header_format = Format::new()
        .set_bold()
        .set_bg_color(FormatColor::Gray)
        .set_align(FormatAlignment::Center);
    
    let currency_format = Format::new()
        .set_num_format("￥#,##0.00");
    
    let highlight_format = Format::new()
        .set_bg_color(FormatColor::Yellow);

    // 4. 写入表头
    worksheet.write_string_with_format(0, 0, "产品名称", &header_format)?;
    worksheet.write_string_with_format(0, 1, "季度1", &header_format)?;
    worksheet.write_string_with_format(0, 2, "季度2", &header_format)?;
    worksheet.write_string_with_format(0, 3, "季度3", &header_format)?;

    // 5. 写入数据
    let products = ["笔记本", "手机", "平板"];
    let sales = [
        [12500.0, 14300.0, 16200.0],
        [8800.0, 9200.0, 10500.0],
        [6500.0, 7200.0, 6800.0]
    ];
    
    for (row, (&product, sales_data)) in products.iter().zip(sales.iter()).enumerate() {
        let row = row + 1; // 从第2行开始
        
        // 写入产品名称
        worksheet.write_string(row, 0, product, None)?;
        
        // 写入销售数据
        for (col, &amount) in sales_data.iter().enumerate() {
            let col = col + 1;
            worksheet.write_number(row, col as u16, amount, Some(&currency_format))?;
            
            // 高亮显示超过1万的销售额
            if amount > 10000.0 {
                worksheet.write_blank(row, col as u16, Some(&highlight_format))?;
            }
        }
    }

    // 6. 添加汇总公式
    let last_row = products.len() as u32;
    worksheet.write_string(last_row + 1, 0, "总计", Some(&header_format))?;
    worksheet.write_formula(last_row + 1, 1, "=SUM(B2:B4)", Some(&currency_format))?;
    worksheet.write_formula(last_row + 1, 2, "=SUM(C2:C4)", Some(&currency_format))?;
    worksheet.write_formula(last_row + 1, 3, "=SUM(D2:D4)", Some(&currency_format))?;

    // 7. 创建图表
    let mut chart = workbook.add_chart(ChartType::Column)?;
    chart.add_series(
        Some("'销售数据'!$A$2:$A$4"),
        Some("'销售数据'!$B$2:$B$4"),
        Some("Q1销售"),
    )?;
    chart.add_series(
        Some("'销售数据'!$A$2:$A$4"),
        Some("'销售数据'!$C$2:$C$4"),
        Some("Q2销售"),
    )?;
    chart.set_title("季度销售对比");
    worksheet.insert_chart(1, 5, &chart, None)?;

    // 8. 保存文件
    workbook.close()?;
    println!("Excel文件生成成功！");
    Ok(())
}

这个综合示例演示了：

1. 创建工作表并设置列宽
2. 多种单元格格式的应用
3. 数据批量写入
4. 条件格式高亮
5. 公式计算
6. 图表创建
7. 中文内容支持

注意事项：

1. 实际使用时请确保已添加xlsxwriter依赖
2. 格式对象可以复用以提高性能
3. 大数据量建议分批写入
4. 生成的文件可以用Excel直接打开查看效果