百科.dev
全部条目在线工具AI 编程趋势榜开源项目技术资讯提交条目
登录
< 返回工具列表
R

rust_xlsxwriter

> 编程语言
开源

一个用于创建 Excel XLSX 文件的 Rust 库.

577 stars0 点赞1 次浏览
访问官网GitHub

工具介绍

一个用于创建 Excel XLSX 文件的 Rust 库.

rust_xlsxwriter

The rust_xlsxwriter library is a Rust crate for writing Excel files in the xlsx format.

The rust_xlsxwriter crate can be used to write text, numbers, dates, and formulas to multiple worksheets in a new Excel 2007+ .xlsx file. It has a focus on performance and fidelity with the file format created by Excel. It cannot be used to modify an existing file.

Example

Sample code to generate the Excel file shown above.

…

rust_xlsxwriter is a rewrite of the Python XlsxWriter library in Rust by the same author, with additional Rust-like features and APIs. The supported features are:

  • Support for writing all basic Excel data types.
  • Full cell formatting support.
  • Formula support, including new Excel 365 dynamic functions.
  • Charts.
  • Hyperlink support.
  • Page/Printing Setup support.
  • Merged ranges.
  • Conditional formatting.
  • Data validation.
  • Cell Notes.
  • Textboxes.
  • Checkboxes.
  • Sparklines.
  • Worksheet PNG/JPEG/GIF/BMP images.
  • Workbook themes.
  • Rich multi-format strings.
  • Outline groupings.
  • Defined names.
  • Autofilters.
  • Worksheet Tables.
  • Serde serialization support.
  • Support for macros.
  • Memory optimization mode for writing large files.

Motivation

The rust_xlsxwriter crate was designed and implemented based around the following design considerations:

  • Fidelity with the Excel file format. In most cases the output matches the output from Excel exactly.
  • Performance. The library is within 10% of the similar C library and it also supports a constant memory mode for writing large files.
  • Comprehensive documentation. There is extensive API documentation as well as user guides, a tutorial, and a cookbook of examples.
  • Feature richness. The library supports a wide range of Excel features, including charts, conditional formatting, data validation, rich text, hyperlinks, images, and even sparklines.
  • Write only. The library only supports writing Excel files, and not reading or modifying them.
  • A family of libraries. The rust_xlsxwriter library has sister libraries written in C (libxlsxwriter), Python (XlsxWriter), and Perl (Excel::Writer::XLSX), by the same author. Bug fixes and improvements in one get transferred to the others.
  • No FAQ section. The Rust implementation seeks to avoid some of the required workarounds and API mistakes of the other language variants.

Performance

As mentioned above the rust_xlsxwriter library has sister libraries written natively in C, Python, and Perl.

A relative performance comparison between the C, Rust, and Python versions is shown below. The Perl performance is similar to the Python library, so it has been omitted.

Library Relative to C Relative to Rust
C/libxlsxwriter 1.00
rust_xlsxwriter 1.14 1.00
Python/XlsxWriter 4.36 3.81

The C version is the fastest: it is 1.14 times faster than the Rust version and 4.36 times faster than the Python version. The Rust version is 3.81 times faster than the Python version.

See the Performance section for more details.

Crate Features

The following is a list of the features supported by the rust_xlsxwriter crate.

Default

  • default: This includes all the standard functionality. The only dependency is the zip crate.

rust_xlsxwriter can be added to a Rust project as follows:

bash
cargo add rust_xlsxwriter

Optional features

These are all off by default.

  • constant_memory: Keeps memory usage to a minimum when writing large files. See Constant Memory Mode.
  • enhanced_autofit: Adds support for autofitting formatted numbers and dates via the ssfmt crate.
  • serde: Adds support for Serde serialization.
  • chrono: Adds support for Chrono date/time types to the API. See IntoExcelDateTime.
  • jiff: Adds support for Jiff date/time types to the API. See IntoExcelDateTime.
  • zlib: Improves performance of the zlib crate but adds a dependency on zlib and a C compiler. This can be up to 1.5 times faster for large files.
  • polars: Adds support for mapping between PolarsError and rust_xlsxwriter::XlsxError. See also polars_excel_writer.
  • wasm: Adds a dependency on js-sys and wasm-bindgen to allow compilation for wasm/JavaScript targets. See also wasm-xlsxwriter.
  • rust_decimal: Adds support for writing the rust_decimal Decimal.
  • zmij: Adds a dependency on zmij. This speeds up writing numeric worksheet cells by around 10%. See the Performance documentation.

A rust_xlsxwriter feature can be enabled in your Cargo.toml file as follows:

bash
cargo add rust_xlsxwriter -F constant_memory

Release notes

Recent changes:

  • Added support for writing directly to STDOUT.
  • Added support for autofitting formatted numbers and dates.
  • Added support for workbook themes.

See the full Release Notes and Changelog.

See also

  • User Guide: Working with the rust_xlsxwriter library.
    • Getting started: A simple getting started guide on how to use rust_xlsxwriter in a project and write a Hello World example.
    • Tutorial: A larger example of using rust_xlsxwriter to write some expense data to a spreadsheet.
    • Cookbook.
  • The rust_xlsxwriter crate.
  • The rust_xlsxwriter API docs at docs.rs.
  • The rust_xlsxwriter repository.
  • Roadmap of planned features.

Issues· 0 开放

查看全部 Issues在 GitHub 打开

暂无开放 Issues,或尚未同步最近议题。

> 标签

Rustlibxlsxwriterrustxlsxxlsxwriter

暂无评论,来聊聊你的看法吧

> 工具信息

发布日期2026年8月1日
最后更新2026年9月17日
分类编程语言
定价开源

> 相关工具

T
TypeScript
JavaScript 的超集,为前端与全栈提供静态类型
P
Python
通用编程语言,广泛用于 Web、数据与 AI
G
Go
Google 推出的简洁高效系统语言