Struct office::Excel

pub struct Excel { /* fields omitted */ }

A wrapper struct over the Excel file

Methods

impl Excel

fn open<P: AsRef<Path>>(path: P) -> Result<Excel>

Opens a new workbook

Examples

use office::Excel;

assert!(Excel::open(path).is_ok());

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

Get all data from Worksheet

Examples

use office::Excel;

let mut workbook = Excel::open(path).unwrap();
let range = workbook.worksheet_range("Sheet1").unwrap();

fn has_vba(&mut self) -> bool

Does the workbook contain a vba project

fn vba_project(&mut self) -> Result<Cow<VbaProject>>

Gets vba project

Examples

use office::Excel;

let mut workbook = Excel::open(path).unwrap();
if workbook.has_vba() {
    let mut vba = workbook.vba_project().unwrap();
    println!("References: {:?}", vba.get_references());
    println!("Modules: {:?}", vba.get_module_names());
}

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

Get all sheet names of this workbook

Examples

use office::Excel;

let mut workbook = Excel::open(path).unwrap();
println!("Sheets: {:#?}", workbook.sheet_names());