Crate simple_excel_writer

simple_excel_writer

Simple Excel Writer

Install

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

[dependencies]
simple_excel_writer="*"

Sample

extern crate simple_excel_writer as excel;
use excel::*;

fn main() {
    println!("hello");

    let mut wb = Workbook::create("/tmp/b.xlsx");
    let mut sheet = wb.create_sheet("Sheet2");

    /*
        // set column width
        sheet.add_column(Column { custom_width: 1.0, width: 50.0 });
        sheet.add_column(Column { custom_width: 1.0, width: 50.0 });
        sheet.add_column(Column { custom_width: 1.0, width: 150.0 });
    */

    wb.write_sheet(&mut sheet, |sheet_writer| {
        let mut r = Row::new();
        r.add_cell(1, true);
        r.add_cell(2, "Hello");
        sheet_writer.append_row(r)?;
        //        r.write(writer)?;

        sheet_writer.append_empty_rows(10);

        r = Row::new();
        r.add_cell(1, 3.6);
        r.add_cell(2, "World");
        r.add_cell(3, "!");
        sheet_writer.append_row(r)
        //        r.write(writer)
    }).expect("write excel error!");

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

Reexports

pub use sheet::*;

pub use workbook::*;

Modules

sheet
workbook