ImportOptions Enumeration

In This Topic

Represents options for importing process.

Syntax

'Declaration
 
<FlagsAttribute()>
Public Enum ImportOptions 
   Inherits System.Enum

'Usage
 
Dim instance As ImportOptions

[Flags()]
public enum ImportOptions : System.Enum

Members

Member	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.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Spreadsheet.IO.OpenXml.ImportOptions