tafia / calamine

A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
MIT License
1.6k stars 155 forks source link

Not all table rows are included in data() #415

Open rtiagom opened 3 months ago

rtiagom commented 3 months ago
    let path = format!("{}/ctryprem.xlsx", "/tmp");
    let workbook: Result<Xlsx<std::io::BufReader<std::fs::File>>, calamine::XlsxError> = open_workbook(path);
    if let Ok(mut workbook) = workbook {
        workbook.load_tables()?;
        let tables = workbook.table_names_in_sheet("ERPs by country");
        println!("Tables loaded");
        println!("Defined Tables: {:?}", tables);
        let table = workbook.table_by_name("Table1")?;
        println!("columns: {:?}", table.columns());
        println!("data {:#?}", table.data());

Missing the last 4 rows. Here's the original file https://www.stern.nyu.edu/~adamodar/pc/datasets/ctryprem.xlsx.