Crate umya_spreadsheet

Example

Reader or New File

use umya_spreadsheet::*;

// reader
let path = std::path::Path::new("./tests/test_files/aaa.xlsx");
let mut book = reader::xlsx::read(path).unwrap();
// or
// lazy reader
//  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 = reader::xlsx::lazy_read(path).unwrap();
// or
// new file
let mut book = new_file();

New worksheet

use umya_spreadsheet::*;
let mut book = new_file();

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

Copy worksheet

use umya_spreadsheet::*;
let mut book = new_file();

let mut clone_sheet = book.get_sheet(&0).unwrap().clone();
clone_sheet.set_name("New Sheet");
let _ = book.add_sheet(clone_sheet);

Change value

use umya_spreadsheet::*;
let mut book = new_file();
let _ = book.new_sheet("Sheet2");

// change value
book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("A1").set_value("TEST1");
book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("B2").set_value_from_i32(1);
book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("C3").set_value_from_bool(true);
// or
book.get_sheet_mut(&1).unwrap().get_cell_by_column_and_row_mut(&1, &1).set_value("TEST1");
book.get_sheet_mut(&1).unwrap().get_cell_by_column_and_row_mut(&2, &2).set_value_from_i32(1);
book.get_sheet_mut(&1).unwrap().get_cell_by_column_and_row_mut(&3, &3).set_value_from_bool(true);

Read value

use umya_spreadsheet::*;
let mut book = new_file();
let _ = book.new_sheet("Sheet2");
book.get_sheet_by_name_mut("Sheet2").unwrap().get_cell_mut("A1").set_value("TEST1");

// read value
let a1_value = book.get_sheet_by_name("Sheet2").unwrap().get_value("A1");
// or
let a1_value = book.get_sheet(&1).unwrap().get_value_by_column_and_row(&1, &1);
// or formatted value
let a1_value = book.get_sheet(&1).unwrap().get_formatted_value("A1");
assert_eq!("TEST1", a1_value);  // TEST1

Change style

more example is here.

use umya_spreadsheet::*;
let mut book = new_file();
let _ = book.new_sheet("Sheet2");

// add bottom border
book.get_sheet_by_name_mut("Sheet2").unwrap()
.get_style_mut("A1")
.get_borders_mut()
.get_bottom_mut()
.set_border_style(Border::BORDER_MEDIUM);
// or
book.get_sheet_mut(&1).unwrap()
.get_style_by_column_and_row_mut(&1, &1)
.get_borders_mut()
.get_bottom_mut()
.set_border_style(Border::BORDER_MEDIUM);

Insert or Remove Rows(or Columns)

use umya_spreadsheet::*;
let mut book = new_file();

// insert rows
book.insert_new_row("Sheet1", &2, &3);

// insert columns
book.insert_new_column("Sheet1", "B", &3);
// or
book.insert_new_column_by_index("Sheet1", &2, &3);

// remove rows
book.remove_row("Sheet1", &6, &2);

// remove columns
book.remove_column("Sheet1", "F", &2);
// or
book.remove_column_by_index("Sheet1", &6, &2);

Writer

use umya_spreadsheet::*;
let mut book = new_file();
let _ = book.new_sheet("Sheet2");

// writer
let path = std::path::Path::new("C:/spread_test_data/ccc.xlsx");
let _ = writer::xlsx::write(&book, path);

Re-exports

pub use self::structs::*;

Modules

helper

reader

file reader library.

structs

store structs.

writer

file writer library.

Functions

new_file

create new spreadsheet file.

new_file_empty_worksheet

create new spreadsheet file. not include worksheet. At least one additional worksheet must be added before the correct file can be generated.