Struct Xlsx

pub struct Xlsx<RS> { /* private fields */ }

A struct representing xml zipped excel file Xlsx, Xlsm, Xlam

Implementations

impl<RS: Read + Seek> Xlsx<RS>

pub fn load_tables(&mut self) -> Result<(), XlsxError>

Load the tables from

pub fn table_names(&self) -> Vec<&String>

Get the names of all the tables

pub fn table_names_in_sheet(&self, sheet_name: &str) -> Vec<&String>

Get the names of all the tables in a sheet

pub fn table_by_name( &mut self, table_name: &str, ) -> Option<Result<Table<DataType>, XlsxError>>

Get the table by name

Trait Implementations

impl<RS: Read + Seek> Reader<RS> for Xlsx<RS>

type Error = XlsxError

Error specific to file type

fn new(reader: RS) -> Result<Self, XlsxError>

Creates a new instance.

fn vba_project(&mut self) -> Option<Result<Cow<'_, VbaProject>, XlsxError>>

Gets VbaProject

fn metadata(&self) -> &Metadata

Initialize

fn worksheet_range( &mut self, name: &str, ) -> Option<Result<Range<DataType>, XlsxError>>

Read worksheet data in corresponding worksheet path

fn worksheet_formula( &mut self, name: &str, ) -> Option<Result<Range<String>, XlsxError>>

Read worksheet formula in corresponding worksheet path

fn worksheets(&mut self) -> Vec<(String, Range<DataType>)>

Fetch all worksheet data & paths

fn sheet_names(&self) -> Vec<String>

Get all sheet names of this workbook, in workbook order

fn sheets_metadata(&self) -> &[Sheet]

Fetch all sheets metadata

fn defined_names(&self) -> &[(String, String)]

Get all defined names (Ranges names etc)

fn worksheet_range_at( &mut self, n: usize, ) -> Option<Result<Range<DataType>, Self::Error>>

Get the nth worksheet. Shortcut for getting the nth sheet_name, then the corresponding worksheet.