simple_excel_writer

用 Rust 编写的 simple_excel_writer

文档

示例

#[macro_use]
extern crate simple_excel_writer as excel;

use excel::*;

fn main() {
    let mut wb = Workbook::create("/tmp/b.xlsx");
    let mut sheet = wb.create_sheet("SheetName");

    // set column width
    sheet.add_column(Column { width: 30.0 });
    sheet.add_column(Column { width: 30.0 });
    sheet.add_column(Column { width: 80.0 });
    sheet.add_column(Column { width: 60.0 });

    wb.write_sheet(&mut sheet, |sheet_writer| {
        let sw = sheet_writer;
        sw.append_row(row!["Name", "Title","Success","XML Remark"])?;
        sw.append_row(row!["Amy", (), true,"<xml><tag>\"Hello\" & 'World'</tag></xml>"])?;
        sw.append_blank_rows(2);
        sw.append_row(row!["Tony", blank!(2), "retired"])
    }).expect("write excel error!");

    let mut sheet = wb.create_sheet("Sheet2");
    wb.write_sheet(&mut sheet, |sheet_writer| {
        let sw = sheet_writer;
        sw.append_row(row!["Name", "Title","Success","Remark"])?;
        sw.append_row(row!["Amy", "Manager", true])
    }).expect("write excel error!");

    wb.close().expect("close excel error!");
}

待办事项

• 支持样式

变更日志

0.2.0 (2022-03-11)

• 支持 WASM !

0.1.9 (2021-10-28)

• 支持公式
• 支持 NaiveDate & NaiveDateTime
• 格式化日期和时间
• 工作表名称验证
• 移除不必要的 bzip2 依赖

感谢所有贡献者！

0.1.7 (2020-04-29)

• 支持内存中创建模式，感谢 Maxburke。

This change creates all worksheet files in-memory and only writes them
to disk once the XLSX file is closed.

A new option for creating a version that is in-memory only is available
with `Worksheet::create_in_memory()` which returns the buffer holding
the completed XLSX file contents when closed.

0.1.6 (2020-04-06)

• 支持工作表间的共享字符串，感谢 Mikael Edlund。

0.1.5 (2019-03-21)

• 支持 Windows 平台，感谢 Carl Fredrik Samson。

0.1.4 (2017-03-24)

• 转义 XML 字符。

0.1.3 (2017-01-03)

• 支持 26+ 列。
• 修复列宽错误。

0.1.2 (2017-01-02)

• 支持多个工作表

0.1 (2017-01-01)

• 生成基本的 xlsx 文件

许可证

Apache-2.0