Struct ExcelReader 

pub struct ExcelReader { /* private fields */ }

An Excel file reader supporting .xlsx format.

Uses the calamine crate for parsing. Available when the format-excel feature is enabled.

Example

use plotlars_core::io::ExcelReader;

let df = ExcelReader::new("data/report.xlsx")
    .sheet("Q1 Sales")
    .finish()
    .unwrap();

Implementations

impl ExcelReader

pub fn new(path: impl AsRef<Path>) -> ExcelReader

Create a new Excel reader for the given file path.

pub fn sheet(self, sheet: &str) -> ExcelReader

Select the sheet to read by name. Defaults to the first sheet.

pub fn has_header(self, has_header: bool) -> ExcelReader

Set whether the first row is a header row. Defaults to true.

pub fn skip_rows(self, skip_rows: usize) -> ExcelReader

Set the number of rows to skip before reading data.

pub fn finish(self) -> Result<DataFrame, PlotlarsError>

Execute the read and return a DataFrame.

Errors

Returns PlotlarsError::ExcelParse if the file cannot be read or parsed.

Trait Implementations

impl Clone for ExcelReader

fn clone(&self) -> ExcelReader

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.