Struct calamine::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 ) -> Result<Table<Data>, XlsxError>

Get the table by name

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

pub fn worksheet_cells_reader<'a>( &'a mut self, name: &str ) -> Result<XlsxCellReader<'a>, XlsxError>

Get a reader over all used cells in the given worksheet cell reader

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

Get worksheet range where shared string values are only borrowed

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) -> Result<Range<Data>, XlsxError>

Read worksheet data in corresponding worksheet path

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

Read worksheet formula in corresponding worksheet path

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.