umya-spreadsheet

Description

umya-spreadsheet is a library written in pure Rust and read and write xlsx file.

Caution

This is BETA version. - It contains many bugs. - Often changes are not backward compatible.

Example

```rust extern crate umya_spreadsheet;

// reader let path = std::path::Path::new("C:/spreadtestdata/aaa.xlsx"); let mut book = umyaspreadsheet::reader::xlsx::read(path).unwrap(); // or // new file let mut book = umyaspreadsheet::new_file();

// new worksheet let _ = book.new_sheet("Sheet2");

// change value let _ = book.getsheetbynamemut("Sheet2").unwrap().getcellmut("A1").setvalue("TEST1"); // or let _ = book.getsheetmut(1).getcellbycolumnandrowmut(1, 1).setvalue("TEST1");

// read value let a1value = book.getsheetbyname("Sheet2").unwrap().getcell("A1").unwrap().getvalue(); // or let a1value = book.getsheet(1).unwrap().getcellbycolumnandrow(1, 1).unwrap().getvalue(); asserteq!("TEST1", a1value); // TEST1

// add bottom border let _ = book.getsheetbynamemut("Sheet2").unwrap() .getstylemut("A1") .getbordersmut() .getbottommut() .setborderstyle(umyaspreadsheet::Border::BORDERMEDIUM);

// writer let path = std::path::Path::new("C:/spreadtestdata/bbb.xlsx"); let _ = umya_spreadsheet::writer::xlsx::write(&book, path); ```

License

MIT