spsheet-rs

A xlsx or ods read and write library

Documentation

Description

spsheet-rs is is a pure Rust library to read and write any xlsx and ods file.

Features

• [x] xlsx Read
• [x] xlsx Write
• [x] ods Read
• [x] ods Write
• [x] Cell Value
• [ ] Cell Date Format(partialy support)
• [ ] Cell Digit Format
• [ ] Cell Border
• [ ] Cell Color
• [ ] Cell Width
• [ ] Cell Hegiht
• [ ] Formular

Examples

```rust extern crate spsheet; use spsheet::ods; use spsheet::xlsx; use spsheet::{Book,Sheet,Cell}; use spsheet::style::Style; use std::path::Path;

let mut book = Book::new(); let mut sheet = Sheet::new("シート1"); sheet.addcell(Cell::str("a"), 0, 0); sheet.addcell(Cell::str("b"), 0, 1); sheet.addcell(Cell::float(1.0), 1, 0); sheet.addcell(Cell::float(2.0), 1, 1); sheet.addcell(Cell::datewithstyle("2017-12-02", Style::new("MM\月DD\日")), 2, 0); sheet.addcell(Cell::datewithstyle("2017-12-02T13:30:00", Style::new("YYYY/MM/DD\ HH:MM:SS")), 2, 1); book.add_sheet(sheet);

let _ = ods::write(&book, Path::new("./tests/test.ods")); let res = ods::read(Path::new("./tests/test.ods")).unwrap(); assert_eq!(book, res);

let _ = xlsx::write(&book, Path::new("./tests/test.xlsx")); let res = xlsx::read(Path::new("./tests/test.xlsx")).unwrap(); assert_eq!(book, res); ```

If I can find Google Shreadsheet API Library in Rust, I'll support Google Shpeadsheet.