crabxl 0.1.0-alpha.11

A Rust spreadsheet library with bounded streaming XLSX reads
Documentation 
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
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124

//! Rust spreadsheet processing with bounded streaming XLSX reads.
//!
//! Reads include sparse scalars, bounded plain/rich strings, numeric and ISO dates,
//! shared style catalogs and normal formulas. Sequential creation shares the core models. Other
//! spreadsheet features remain planned; unsupported selected cells fail loudly.
//!
//! ```no_run
//! use crabxl::{AccessPattern, MemoryPolicy, ReadData, WorkbookReader};
//! # fn main() -> crabxl::Result<()> {
//! let mut workbook = WorkbookReader::open("numbers.xlsx")?;
//! let output = workbook.read_with_policy(
//!     "Sheet", AccessPattern::RepeatedAccess, MemoryPolicy::default(),
//! )?;
//! println!("{:?}", output.decision);
//! match output.data {
//!     ReadData::Materialized(sheet) => println!("{} rows", sheet.rows.len()),
//!     ReadData::Streaming(mut rows) => while let Some(row) = rows.next_row()? {
//!         println!("{:?}", row.index);
//!     },
//! }
//! # Ok(())
//! # }
//! ```

pub use crabxl_core::{
    AccessPattern, AutoMemory, DecisionReason, MemoryPolicy, MemorySource, ReadDecision, ReadMode,
};
pub use crabxl_core::{
    Cell, CellAddress, CellValue, ColumnIndex, Error, ErrorKind, MAX_COLUMNS, MAX_ROWS,
    ReadOptions, ResourceLimits, Result, Row, RowBatch, RowIndex, SheetData,
};
pub use crabxl_core::{
    CellError, CellText, ExactInteger, StyleComponent, StyleId, StyleInteger, parse_iso8601,
};
pub use crabxl_xlsx::{AdaptiveRead, ReadData};
pub use crabxl_xlsx::{LoadOptions, LoadedWorkbook};
pub use crabxl_xlsx::{Rows, SheetInfo, SheetKind, WorkbookReader};

pub use crabxl_xlsx::{
    FormulaWritePolicy, NonFiniteWritePolicy, StyleWritePolicy, WorkbookWriter, WriteOptions,
    WriteStats,
};

pub use crabxl_core::{
    BorderLine, BorderSide, CellStyle, DateEpoch, DateKind, ExcelDateTime, Font, Formula,
    HorizontalAlignment, VerticalAlignment,
};

pub use crabxl_core::{ActiveViewSelection, normalize_active_view, resolve_sheet_index};
pub use crabxl_core::{CellRange, EditLimits, SheetVisibility, Worksheet, WorksheetRange};
pub use crabxl_core::{Hyperlink, Hyperlinks};
pub use crabxl_core::{MergedCellRange, MergedRangeIter, MergedRanges};
pub use crabxl_xlsx::{HyperlinkOutput, visit_owned_hyperlink_ids};
pub use crabxl_xlsx::{read_rich_text, write_rich_text};

pub use crabxl_xlsx::{
    CalculationChainPolicy, EditorOptions, PartInfo, SaveOptions, SaveStats, WorkbookEditor,
};

pub use crabxl_core::MemoryAllowance;
pub use crabxl_xlsx::memory_allowance;

pub use crabxl_core::{
    FormulaToken, TokenKind, TokenSubtype, classify_formula_operand, tokenize_formula,
};
pub use crabxl_core::{formula_position, translate_axis, translate_expression};

pub use crabxl_core::{
    OwnedWorksheets, SheetId, Workbook, WorkbookLimits, WorkbookParts, WorksheetEditor,
};

pub use crabxl_xlsx::{SharedStringOptions, SharedStringStats, SharedStringStorage};

pub use crabxl_core::{
    ArgbLiteral, Color, ColorKind, FontScheme, PhoneticProperties, PhoneticRun, RichText,
    RichTextRun, RunFont, TextVerticalAlignment, Underline,
};

pub use crabxl_core::{
    Alignment, Border, Fill, FillPattern, GradientFill, GradientKind, GradientStop, PatternFill,
    Protection,
};

pub use crabxl_core::{
    CellFormat, NamedStyle, NamedStyleOptions, NumberFormat, StyleCatalog, StyleView,
};

pub use crabxl_core::DateReadPolicy;

pub use crabxl_core::{
    DataTableOptions, FormulaAnnotations, FormulaFlag, FormulaFlags, FormulaMetadata, FormulaRange,
    FormulaReference, FormulaType, SharedFormulaIndex,
};

pub use crabxl_core::FormulaReadPolicy;

pub use crabxl_xlsx::SharedFormulaStats;

pub use crabxl_core::{
    BUILTIN_NUMBER_FORMATS, builtin_number_format, builtin_number_format_id, classify_number_format,
};

pub use crabxl_core::{StyleLimits, StyleRegistry, TemporalStyleIds};

pub use crabxl_core::{
    Theme, ThemeCatalog, ThemeColor, ThemeFontCollection, ThemeScriptFont, ThemeTypeface,
};
pub use crabxl_xlsx::ThemeWritePolicy;

pub use crabxl_core::CellMetadataReadPolicy;

pub use crabxl_core::{
    DifferentialStyle, TableStyle, TableStyleCatalog, TableStyleElement, TableStyleRegion,
};

pub use crabxl_core::{Pane, PanePosition, PaneState, Selection, SheetView, SheetViews, ViewMode};

pub use crabxl_core::{
    PageBreak, PageMargins, PageOrder, PageOrientation, PageSetup, PaperDimension, PrintOptions,
    PrintSettings, PrintSettingsChange, PrintedComments, PrintedErrors,
};

/// Sparse worksheet dimension metadata and shared appearance identities.
pub use crabxl_core::{ColumnDimension, RowDimension, SheetDimensions};