umya-spreadsheet
Description
umya-spreadsheet is a library written in pure Rust and read and write xlsx file.
Example
Reader or New File
extern crate umya_spreadsheet;
// reader
let path = new;
let mut book = read.unwrap;
// or
// new file
let mut book = new_file;
New worksheet
extern crate umya_spreadsheet;
let mut book = new_file;
// new worksheet
let _ = book.new_sheet;
Change value
extern crate umya_spreadsheet;
let mut book = new_file;
let _ = book.new_sheet;
// change value
let _ = book.get_sheet_by_name_mut.unwrap.get_cell_mut.set_value;
// or
let _ = book.get_sheet_mut.get_cell_by_column_and_row_mut.set_value;
Read value
extern crate umya_spreadsheet;
let mut book = new_file;
let _ = book.new_sheet;
// read value
let a1_value = book.get_sheet_by_name.unwrap.get_value;
// or
let a1_value = book.get_sheet.unwrap.get_value_by_column_and_row;
// or formatted value
let a1_value = book.get_sheet.unwrap.get_formatted_value;
assert_eq!; // TEST1
Change style
extern crate umya_spreadsheet;
let mut book = new_file;
let _ = book.new_sheet;
// add bottom border
let _ = book.get_sheet_by_name_mut.unwrap
.get_style_mut
.get_borders_mut
.get_bottom_mut
.set_border_style;
// or
let _ = book.get_sheet_by_name_mut.unwrap
.get_style_by_column_and_row_mut
.get_borders_mut
.get_bottom_mut
.set_border_style;
Insert or Remove Rows(or Columns)
extern crate umya_spreadsheet;
let mut book = new_file;
// insert rows
book.insert_new_row;
// insert columns
book.insert_new_colmun;
// or
book.insert_new_colmun_by_index;
// remove rows
book.remove_row;
// remove columns
book.remove_colmun;
// or
book.remove_colmun_by_index;
Writer
extern crate umya_spreadsheet;
let mut book = new_file;
let _ = book.new_sheet;
// writer
let path = new;
let _ = write;
License
MIT