xls

The xls module reads spreadsheet files in xlsx, xls, ods, and xlsb formats (via calamine). Data is returned as a 2D array of primitive values.

/// List sheet names in a workbook.
///
/// To read a workbook from a stream, read it first —
/// `xls::sheets(Read::read_all(f)?)`.
val sheets: fn(input: bytes) -> Result<Array<string>, `XlsErr(string)>;

/// Read a sheet by name as a 2D array of rows.
val read: fn(input: bytes, sheet: string) -> Result<Array<Array<PrimNoErr>>, `XlsErr(string)>;

Example

let data = sys::fs::read_all_bin("report.xlsx")?;
let names = xls::sheets(data)?;
let rows = xls::read(data, names[0]$)?;