#spreadsheet #xlsx #reader-writer #excel #read-file #file-reader #write-file

umya-spreadsheet

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

67 releases (10 stable)

Uses old Rust 2015

1.2.3 Mar 1, 2024
1.1.1 Dec 6, 2023
1.0.3 Oct 25, 2023
0.9.2 Apr 21, 2023
0.1.17-beta Oct 27, 2020

#79 in Parser implementations

Download history 112/week @ 2023-12-22 153/week @ 2023-12-29 183/week @ 2024-01-05 165/week @ 2024-01-12 175/week @ 2024-01-19 219/week @ 2024-01-26 190/week @ 2024-02-02 179/week @ 2024-02-09 191/week @ 2024-02-16 546/week @ 2024-02-23 539/week @ 2024-03-01 280/week @ 2024-03-08 270/week @ 2024-03-15 195/week @ 2024-03-22 388/week @ 2024-03-29 292/week @ 2024-04-05

1,175 downloads per month
Used in 10 crates (9 directly)

MIT license

6.5MB
47K SLoC

umya-spreadsheet

Result Image

Crates.io Github CI Crates.io Join the chat at https://gitter.im/MathNya/umya-spreadsheet GitHub Sponsor

Description

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

Chatting

Please use Gitter for brief chats.

New features

ver 1.2.0

Changing Reference of Option to Optional Reference. (Thank you, agentjill .)

  • This version contains breaking change. here

A helper is provided to enter the date into the cell.

let value = umya_spreadsheet::helper::date::convert_date(2024, 2, 3, 10, 59, 00);
let mut numbering_format = NumberingFormat::default();
numbering_format.set_format_code("dd-mmm-yy");

sheet.get_cell_mut("A1").set_value_number(value);

let result = sheet.get_formatted_value("A1");
assert_eq!("03-Feb-24", result);

Other Bug Fixes.

Usage

Installation

Add the following code to Cargo.toml

[dependencies]
umya-spreadsheet = "1.2.3"

Add the following code to main.rs

extern crate umya_spreadsheet;

Read file

let path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let mut book = umya_spreadsheet::reader::xlsx::read(path).unwrap();

Read file (Lazy)

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.

let path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let mut book = umya_spreadsheet::reader::xlsx::lazy_read(path).unwrap();

New file

let mut book = umya_spreadsheet::new_file();

Write file

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

Write file with password

let path = std::path::Path::new("./tests/result_files/bbb.xlsx");
let _ = umya_spreadsheet::writer::xlsx::write_with_password(&book, path, "password");
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");

Read Value

let mut book = umya_spreadsheet::new_file();
book.get_sheet_by_name("Sheet1").unwrap().get_cell("A1").get_value();
book.get_sheet_by_name("Sheet1").unwrap().get_cell((1, 1)).get_value();
book.get_sheet_by_name("Sheet1").unwrap().get_cell((&1, &1)).get_value();
book.get_sheet_mut(0).unwrap().get_cell((&1, &1)).get_value();

Change Value

let mut book = umya_spreadsheet::new_file();
book.get_sheet_by_name_mut("Sheet1").unwrap().get_cell_mut("A1").set_value("TEST1");
book.get_sheet_mut(0).unwrap().get_cell_mut("A1").set_value("TEST2");

Move Values

let range = "A1:A3";
let row = 10;
let column = 2;
book.get_sheet_by_name_mut("Sheet1").unwrap().move_range(range, &row, &column);

Change Style

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);

New Chart

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);

Struct

Pass the book as a Spreadsheet to modify it in other functions.


let mut book = umya_spreadsheet::new_file();
let _ = book.new_sheet("Sheet2");
update_excel(&mut book);

fn update_excel(book: &mut Spreadsheet) {
   book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("A1").set_value("Test"); 
}

See the next chapter for implementation status and more detailed usage.

Support Status

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.)

License

MIT

Contributing

Contributions by way of pull requests are welcome! Please make sure your code uses:

  • cargo fmt for formatting
  • clippy

Dependencies

~25–35MB
~405K SLoC