WorkbookParseOptions

12 Sep 20251 minute to read

Provides options to control how an Excel file is parsed and loaded into the Spreadsheet during open operations.
These settings help improve performance and customize the import behavior.

Properties

ignoreChart boolean

Indicates whether to ignore charts during file open.
Skipping charts reduces memory usage and improves load time for files with chart objects.

ignoreConditionalFormat boolean

Indicates whether to ignore conditional formatting during file open.
Disabling conditional formatting improves performance and reduces memory usage for files with complex formatting rules.

ignoreFormat boolean

Indicates whether to ignore number and date/time formats.
If true, raw values are loaded without applying display formatting.

ignoreFormula boolean

Indicates whether to ignore formulas during file open.
If true, formula cells are loaded with their last calculated values instead of parsing the formula expressions.

ignoreImage boolean

Indicates whether to ignore images during file open.
Skipping images helps reduce the size of the JSON response and improves performance for image-heavy files.

ignoreMergedCell boolean

Indicates whether to ignore merged cells during file open.
This can improve performance when merged cell information is not required.

ignoreStyle boolean

Indicates whether to ignore cell styles (fonts, colors, borders, etc.) during file open.
Improves performance by skipping style parsing.

ignoreValidation boolean

Indicates whether to ignore data validations during file open.
Skipping validations can reduce parsing time and memory usage, especially in files with extensive validation rules.