[]
Represents options for importing process.
[Flags]
public enum ImportOptions
<Flags>
Public Enum ImportOptions
Name | Description |
---|---|
CalculationChain | Indicates that calculation chain will be imported to optimize for calculations. |
ColumnHeader | Indicates that the column header will be imported as top rows of the worksheet. |
DataOnly | Indicates that only cell values (included formulas if NoFormulas is off) are imported. |
Default | Indicates that default options will be used. It balances the performance of importing process and next actions. |
Exchangeable | Spread data will be imported from extensions of OpenXML file format. |
NoFormulas | Indicates that cell formulas aren't imported. |
RowHeader | Indicates that the row header will be imported as left columns of the worksheet. |
StopRecalculate | Indicates that recalculation after loading Excel file will be avoided. |
TruncateEmptyRowsAndColumns | Truncates empty rows and columns to improve performance. |