Enum Sheets

pub enum Sheets<RS> {
    Xls(Xls<RS>),
    Xlsx(Xlsx<RS>),
    Xlsb(Xlsb<RS>),
    Ods(Ods<RS>),
}

A wrapper over all sheets when the file type is not known at static time

Variants

Xls(Xls<RS>)

Xls reader

Xlsx(Xlsx<RS>)

Xlsx reader

Xlsb(Xlsb<RS>)

Xlsb reader

Ods(Ods<RS>)

Ods reader

Trait Implementations

impl<RS> Reader<RS> for Sheets<RS>

where RS: Read + Seek,

fn new(_reader: RS) -> Result<Sheets<RS>, <Sheets<RS> as Reader<RS>>::Error>

Creates a new instance.

fn vba_project( &mut self, ) -> Option<Result<Cow<'_, VbaProject>, <Sheets<RS> as Reader<RS>>::Error>>

Gets VbaProject

fn metadata(&self) -> &Metadata

Initialize

fn worksheet_range( &mut self, name: &str, ) -> Option<Result<Range<DataType>, <Sheets<RS> as Reader<RS>>::Error>>

Read worksheet data in corresponding worksheet path

fn worksheet_formula( &mut self, name: &str, ) -> Option<Result<Range<String>, <Sheets<RS> as Reader<RS>>::Error>>

Read worksheet formula in corresponding worksheet path

type Error = Error

Error specific to file type

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

Fetch all worksheet data & paths

fn pictures(&self) -> Option<Vec<(String, Vec<u8>)>>

Get all pictures, tuple as (ext: String, data: Vec)

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.