Crate simple_excel_writer

simple_excel_writer

Simple Excel Writer

Install

Just include another [dependencies.*] section into your Cargo.toml:

[dependencies]
simple_excel_writer="0.1.1"

Sample

#[macro_use]
extern crate simple_excel_writer as excel;

use excel::*;

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

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

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

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

Reexports

pub use sheet::*;

pub use workbook::*;

Modules

sheet
workbook

Macros

blank
row