umya-spreadsheet is a library written in pure Rust and read and write xlsx file.
Please use Gitter for brief chats.
Cell information can now be retrieved from a worksheet loaded with lazy_read.
rust
let path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let mut book = umya_spreadsheet::reader::xlsx::lazy_read(path).unwrap();
let cells = book.get_lazy_read_sheet_cells(&0).unwrap();
let value = cells.get_cell_value((&5, &12)).get_value();
let value = cells.get_cell_value("E12").get_value();
Cell.setvaluefromstring had different behavior in different versions.
This function is deprecated.
From now on, setvalue or setvaluestring.
Changed file compression logic when writing.
The file size is smaller than before, but the processing time is longer.
If you want to use the previous logic, use this method.
rust
umya_spreadsheet::writer::xlsx::write_light(&book, path);
umya_spreadsheet::writer::xlsx::write_with_password_light(&book, path, "password");
The way cells are referenced has changed. ```rust // old let value = worksheet.getvalue("A1"); let value = worksheet.getvaluebycolumnandrow(&1, &1); // This one has been deprecated. // It will eventually disappear.
// NEW let value = worksheet.getvalue("A1"); let value = worksheet.getvalue((1, 1)); let value = worksheet.get_value((&1, &1)); ```
A password can now be set when saving a file.
rust
let path = std::path::Path::new("./tests/result_files/bbb.xlsx");
let _ = umya_spreadsheet::writer::xlsx::write_with_password(&book, path, "password");
rust
let from_path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let to_path = std::path::Path::new("./tests/result_files/bbb.xlsx");
let _ = umya_spreadsheet::writer::xlsx::set_password(&from_path, &to_path, "password");
Add the following code to Cargo.toml
toml
[dependencies]
umya-spreadsheet = "0.9"
Add the following code to main.rs
rust
extern crate umya_spreadsheet;
rust
let path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let mut book = umya_spreadsheet::reader::xlsx::read(path).unwrap();
Delays the loading of the worksheet until it is needed.
When loading a file with a large amount of data, response improvement can be expected.
rust
let path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let mut book = umya_spreadsheet::reader::xlsx::lazy_read(path).unwrap();
rust
let mut book = umya_spreadsheet::new_file();
rust
let path = std::path::Path::new("./tests/result_files/bbb.xlsx");
let _ = umya_spreadsheet::writer::xlsx::write(&book, path);
rust
let path = std::path::Path::new("./tests/result_files/bbb.xlsx");
let _ = umya_spreadsheet::writer::xlsx::write_with_password(&book, path, "password");
rust
let from_path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let to_path = std::path::Path::new("./tests/result_files/bbb.xlsx");
let _ = umya_spreadsheet::writer::xlsx::set_password(&from_path, &to_path, "password");
rust
let mut book = umya_spreadsheet::new_file();
let _ = book.new_sheet("Sheet2");
book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("A1").set_value("TEST1");
rust
let mut book = umya_spreadsheet::new_file();
let mut style = book.get_sheet_by_name_mut("Sheet1").unwrap().get_style_mut("A1");
// fill color on red.
style.set_background_color(umya_spreadsheet::Color::COLOR_RED);
rust
let mut book = umya_spreadsheet::new_file();
// Add Chart
let mut from_marker = umya_spreadsheet::structs::drawing::spreadsheet::MarkerType::default();
from_marker.set_coordinate("C1");
let mut to_marker = umya_spreadsheet::structs::drawing::spreadsheet::MarkerType::default();
to_marker.set_coordinate("D11");
let area_chart_series_list = vec![
"Sheet1!$A$1:$A$10",
"Sheet1!$B$1:$B$10",
];
let mut chart = umya_spreadsheet::structs::Chart::default();
chart.new_chart(
umya_spreadsheet::structs::ChartType::LineChart,
from_marker,
to_marker,
area_chart_series_list,
);
book.get_sheet_by_name_mut("Sheet1").unwrap()
.add_chart(chart);
See the next chapter for implementation status and more detailed usage.
| Function | detail | example | | --- | --- | --- | | file reader | xlsx, xlsm | here. | | file lazy_reader | xlsx, xlsm | here. | | file writer | xlsx, xlsm | here. | | | csv | here. | | file writer with password | xlsx, xlsm | here. | | worksheet | read, new, copy | here. | | cell value | read, edit, formated value. | here. | | cell style | read, edit | here. | | columns | read, edit, auto width | here. | | rows | read, edit | | | charts | read, edit | here. | | drawings | read, edit(Still might be inconvenient.) | | | images | read, edit | here. | | ole objects | read, edit(Still might be inconvenient.) | |
MIT