Crate xlsx_batch_reader

An Excel/OpenDocument Spreadsheets file batch reader, in pure Rust. This crate supports Office 2007 or newer file formats(xlsx, xlsm, etc). The most obvious difference from other Excel file reading crates is that it does not read the whole file into memory, but read in batches. So that it can maintain low memory usage, especially when reading large files.

Re-exports

pub use chrono;

Modules

read

Excel file reader

write

Excel file writer

Structs

Timesecond

seconds since midnight

Timestamp

seconds since UNIX epoch

Enums

CellValue

Cell Value Type

Statics

MAX_COL_NUM

max column number

MAX_ROW_NUM

max row number

Functions

get_num_from_ord

Convert character based Excel cell column addresses to number. If you pass parameter D to this function, you will get 4

get_ord_from_num

Convert number based Excel cell column addresses to character. If you pass parameter 4 to this function, you will get D

get_ord_from_tuple

Convert numbers based Excel cell addresses to characters. If you pass parameter (2, 4) to this function, you will get D2.

get_tuple_from_ord

Convert character based Excel cell addresses to numbers. If you pass parameter D2 to this function, you will get (2, 4)

is_merged_cell

check whether the cell is a merged cell. If it is the first cell in the merged area, return the size of the merged area. RowNum and ColNum start from 1.

Type Aliases

ColNum

column number

Date32

days since UNIX epoch

MergedRange

merged range

RowNum

row number