Class WorkbookParseOptions

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.

Inheritance

System.Object

WorkbookParseOptions

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Syncfusion.EJ2.Spreadsheet

Assembly: Syncfusion.EJ2.Spreadsheet.dll

Syntax

public class WorkbookParseOptions

Constructors

WorkbookParseOptions()

Declaration

public WorkbookParseOptions()

Properties

IgnoreChart

Gets or sets a value indicating whether to ignore charts during file open. Skipping charts reduces memory usage and improves load time for files with chart objects.

Declaration

public bool IgnoreChart { get; set; }

Property Value

Type
System.Boolean

IgnoreConditionalFormat

Gets or sets a value indicating whether to ignore conditional formatting during file open. Disabling conditional formatting improves performance and reduces memory usage for files with complex formatting rules.

Declaration

public bool IgnoreConditionalFormat { get; set; }

Property Value

Type
System.Boolean

IgnoreFormat

Gets or sets a value indicating whether to ignore number and date/time formats during file open. If true, raw values are loaded without display formatting.

Declaration

public bool IgnoreFormat { get; set; }

Property Value

Type
System.Boolean

IgnoreFormula

Gets or sets a value indicating whether to ignore formulas during file open. If true, formula cells are loaded with their last calculated values instead of parsing the formula expressions.

Declaration

public bool IgnoreFormula { get; set; }

Property Value

Type
System.Boolean

IgnoreImage

Gets or sets a value indicating whether to ignore images during file open. Skipping images helps reduce the size of the JSON response and improves performance for image-heavy files.

Declaration

public bool IgnoreImage { get; set; }

Property Value

Type
System.Boolean

IgnoreMergedCell

Gets or sets a value indicating whether to ignore merged cells during file open. This can improve performance when merged cell information is not required.

Declaration

public bool IgnoreMergedCell { get; set; }

Property Value

Type
System.Boolean

IgnoreStyle

Gets or sets a value indicating whether to ignore cell styles (fonts, colors, borders, etc.) during file open. Improves performance by skipping style extraction and parsing.

Declaration

public bool IgnoreStyle { get; set; }

Property Value

Type
System.Boolean

IgnoreValidation

Gets or sets a value indicating whether to ignore data validations during file open. Skipping validations can reduce parsing time and memory usage, especially in files with extensive validation rules.

Declaration

public bool IgnoreValidation { get; set; }

Property Value

Type
System.Boolean