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;
Copy worksheet
extern crate umya_spreadsheet;
let mut book = new_file;
let mut clone_sheet = book.get_sheet.unwrap.clone;
clone_sheet.set_title;
let _ = book.add_sheet;
Change value
extern crate umya_spreadsheet;
let mut book = new_file;
let _ = book.new_sheet;
// change value
book.get_sheet_by_name_mut.unwrap.get_cell_mut.set_value;
book.get_sheet_by_name_mut.unwrap.get_cell_mut.set_value_from_i32;
book.get_sheet_by_name_mut.unwrap.get_cell_mut.set_value_from_bool;
// or
book.get_sheet_mut.get_cell_by_column_and_row_mut.set_value;
book.get_sheet_mut.get_cell_by_column_and_row_mut.set_value_from_i32;
book.get_sheet_mut.get_cell_by_column_and_row_mut.set_value_from_bool;
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
book.get_sheet_by_name_mut.unwrap
.get_style_mut
.get_borders_mut
.get_bottom_mut
.set_border_style;
// or
book.get_sheet_mut
.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;
Supported chart types
- AreaChart
- Area3DChart
- BarChart
- Bar3DChart
- BubbleChart
- DoughnutChart
- LineChart
- Line3DChart
- OfPieChart
- PieChart
- RadarChart
- ScatterChart
Other types will be supported sequentially.
Add Chart
extern crate umya_spreadsheet;
let mut book = new_file;
// add chart
let mut from_marker = default;
let mut to_marker = default;
from_marker.set_coordinate;
to_marker.set_coordinate;
let area_chart_series_list = vec!;
let mut chart = default;
chart.new_chart;
book.get_sheet_by_name_mut.unwrap.get_worksheet_drawing_mut.add_chart_collection;
License
MIT