umya-spreadsheet

Description

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

Support Status

| Function | Remarks | | --- | --- | | file | read, lazy_read, write | | cell value | read, edit, formated value. | | cell style | read, edit | | columns | read, edit, auto width | | charts | detail to # Supported chart types | | drawings | read, edit(Still might be inconvenient.) | | images | read, edit(Still might be inconvenient.) | | ole objects | read, edit(Still might be inconvenient.) |

Example

example is here.

Supported chart types

• AreaChart
• Area3DChart
• BarChart
• Bar3DChart
• BubbleChart
• DoughnutChart
• LineChart
• Line3DChart
• OfPieChart
• PieChart
• RadarChart
• ScatterChart

Other types will be supported sequentially.

Add Chart

```rust extern crate umya_spreadsheet;

let mut book = umyaspreadsheet::newfile();

// add chart let mut frommarker = umyaspreadsheet::structs::drawing::spreadsheet::MarkerType::default(); let mut tomarker = umyaspreadsheet::structs::drawing::spreadsheet::MarkerType::default(); frommarker.setcoordinate("C1"); tomarker.setcoordinate("D11"); let areachartserieslist = vec![ "Sheet1!$A$1:$A$10", "Sheet1!$B$1:$B$10", ]; let mut chart = umyaspreadsheet::structs::Chart::default(); chart.newchart( umyaspreadsheet::structs::ChartType::LineChart, frommarker, tomarker, areachartserieslist, ); book.getsheetbynamemut("Sheet1").unwrap().getworksheetdrawingmut().addchartcollection(chart); ```

License

MIT