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<Self, Self::Error>

Creates a new instance.

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

Gets VbaProject

fn metadata(&self) -> &Metadata

Initialize

fn worksheet_range(&mut self, name: &str) -> Result<Range<Data>, Self::Error>

Read worksheet data in corresponding worksheet path

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

Read worksheet formula in corresponding worksheet path

type Error = Error

Error specific to file type

fn with_header_row(&mut self, header_row: HeaderRow) -> &mut Self

Set header row (i.e. first row to be read) If header_row is None, the first non-empty row will be used as header row

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

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<Data>, Self::Error>>

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

impl<RS> ReaderRef<RS> for Sheets<RS>

where RS: Read + Seek,

fn worksheet_range_ref<'a>( &'a mut self, name: &str, ) -> Result<Range<DataRef<'a>>, Self::Error>

Get worksheet range where shared string values are only borrowed.

fn worksheet_range_at_ref( &mut self, n: usize, ) -> Option<Result<Range<DataRef<'_>>, Self::Error>>

Get the nth worksheet range where shared string values are only borrowed. Shortcut for getting the nth sheet_name, then the corresponding worksheet.