simple_excel_writer

simple excel writer in Rust

Documentation

##Example

#[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 });

    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), "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!");
}

##Note

Only tested on macOS / Linux for the time being, because it depends on locale zip command ( zip -q -r target.xlsx excel_tmp_dir/*).

##Todo

• use zip crate to compress files to xlsx. (currently error occurs while opening xlsx file generated by zip )
• support style

##Change Log ####0.1.3 (2017-01-03)

• support 26+ columns .
• fix column width bug.

####0.1.2 (2017-01-02)

• support multiple sheets

####0.1 (2017-01-01)

• generate the basic xlsx file

License

Apache-2.0