excel_reader 2.0.2 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90

use excel_reader::{
    excel::Excel, processed::spreadsheet::sheet::worksheet::cell::cell_value::CellValueType,
};

/// Demo for basic usages
///
/// sample Excels: https://create.microsoft.com/en-us/search?query=table&filters=excel
fn main() -> anyhow::Result<()> {
    let path = "examples/sample.xlsx";

    // excel from a reader
    // let reader = BufReader::new(File::open(path)?);
    // let mut excel: Excel<std::io::BufReader<std::fs::File>> = Excel::from_reader(reader)?;

    // excel directly from path
    let mut excel = Excel::from_path(path)?;

    // get basic sheet info
    let sheets = excel.get_sheets()?;
    if sheets.is_empty() {
        println!("Excel contains no sheets");
        return Ok(());
    }
    println!("sheets: ");
    for sheet in sheets.clone() {
        println!("--------");
        println!("id: {}", sheet.sheet_id);
        println!("name: {}", sheet.name);
        println!("type: {:?}", sheet.r#type);
        println!("visiblity: {:?}", sheet.visible_state);
    }
    println!("--------");
    println!("--------");

    // get worksheet detail
    let worksheet = excel.get_worksheet(&sheets[0].clone())?;
    println!("worksheet: {}", worksheet.name);
    println!("dimension: {:?}", worksheet.dimension);
    println!(
        "Use 1904 backward compatibility date system: {:?}",
        worksheet.is_1904
    );
    println!(
        "Calculation reference: {:?}",
        worksheet.calculation_reference_mode
    );
    if !worksheet.clone().merged_cells.is_empty() {
        println!("merged cells: ");
        for (index, merged_cell) in worksheet.clone().merged_cells.iter().enumerate() {
            println!("{}: {:?}", index + 1, merged_cell);
        }
    }
    if !worksheet.clone().tables.is_empty() {
        println!("tables: ");
        for (index, table) in worksheet.clone().tables.iter().enumerate() {
            println!("--------");
            println!("{}: {:?}", index + 1, table.display_name);
            println!("dimension: {:?}", table.dimension);
            println!("columns: {:?}", table.columns);
            println!("table style: {:?}", table.table_style.name);
        }
        println!("--------");
    }

    // get cells (value and style) in a worksheet
    let cells = worksheet.get_cells()?;
    for cell in cells {
        println!("--------");
        println!("coordinate: {:?}", cell.coordinate);
        println!("value {:?}.", cell.value);
        if let CellValueType::Numeric(_) = cell.value {
            println!(
                "Numeric format: {:?}",
                cell.property.numbering_format.format_code
            )
        }
        let properties = cell.property;

        println!("size: {} * {}", properties.width, properties.height);
        println!("hidden : {:?}", properties.hidden);
        println!("show_phonetic : {:?}", properties.show_phonetic);
        println!("hyperlink : {:?}", properties.hyperlink);
        println!("font : {:?}", properties.font);
        println!("border : {:?}", properties.border);
        println!("fill : {:?}", properties.fill);
        println!("alignment : {:?}", properties.alignment);
    }

    Ok(())
}