Adding `xlsxwriter` library as a dependency

Run this command in a terminal, in your project's directory:

cargo add xlsxwriter

To add it manually, edit your project's Cargo.toml file and add to the [dependencies] section:

xlsxwriter = "0.6.1"

The xlsxwriter library will be automatically available globally. Read the xlsxwriter library documentation.

Back to the crate overview.

Readme

xlsxwriter-rs

Rust binding of libxlsxwriter

Supported Features

100% compatible Excel XLSX files.
Full Excel formatting.
Merged cells.
Autofilters.
Data validation and drop down lists.
Worksheet PNG/JPEG images.

Coming soon

Charts.

Feature Flags

no-md5: Disable image de-duplication and remove md5 function. (See upstream document to learn more).
use-openssl-md5: Use OpenSSL implementation of md5 function. (See upstream document to learn more).
system-zlib: Use system zlib instead of included zlib.

Build requirements

LLVM and clang

How to build on windows

Install Visual Studio
Install LLVM
Set environment variable LIBCLANG_PATH as C:\Program Files\LLVM\bin
Run build

Example

Result Image

let workbook = Workbook::new("simple1.xlsx")?;

let mut sheet1 = workbook.add_worksheet(None)?;
sheet1.write_string(0, 0, "Red text", Some(&Format::new().set_font_color(FormatColor::Red)))?;
sheet1.write_number(0, 1, 20., None)?;
sheet1.write_formula_num(1, 0, "=10 B1", None, 30.)?;
sheet1.write_url(
    1,
    1,
    "https://github.com/informationsea/xlsxwriter-rs",
    Some(&Format::new().set_font_color(FormatColor::Blue).set_underline(FormatUnderline::Single)),
)?;
sheet1.merge_range(2, 0, 3, 2, "Hello, world", Some(
    &Format::new().set_font_color(FormatColor::Green).set_align(FormatAlignment::CenterAcross)
                  .set_vertical_align(FormatVerticalAlignment::VerticalCenter)))?;

sheet1.set_selection(1, 0, 1, 2);
sheet1.set_tab_color(FormatColor::Cyan);
workbook.close()?;

Run Example with Cargo

You can explore this example locally following the steps below:

Install LLVM and set LIBCLANG_PATH if you are using windows. (see bindgen doc for details)
clone or fork this repository
git submodule update --init --recursive
- The above command downloads the required C library so we can compile
cargo run --example hello_spreadsheet

You should then see the example in target/simple1.xlsx. Enjoy!

Adding xlsxwriter library as a dependency

Adding `xlsxwriter` library as a dependency