'Declaration <System.FlagsAttribute()> Public Enum ExcelOpenFlags Inherits System.Enum
'Usage Dim instance As ExcelOpenFlags
[System.Flags()] public enum ExcelOpenFlags : System.Enum
'Declaration <System.FlagsAttribute()> Public Enum ExcelOpenFlags Inherits System.Enum
'Usage Dim instance As ExcelOpenFlags
[System.Flags()] public enum ExcelOpenFlags : System.Enum
Member | Description |
---|---|
ColumnHeaders | Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet. |
DataAndFormulasOnly | Loads formulas from the Excel-compatible file into the spreadsheet. |
DataOnly | Loads only the data from the Excel-compatible file into the spreadsheet. |
DoNotRecalculateAfterLoad | Avoids recalculation after loading the Excel-compatible file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate()). |
NoFlagsSet | Opens the spreadsheet from the Excel-compatible file with no special options. |
RowAndColumnHeaders | Loads row headers from frozen columns and column headers from frozen rows. |
RowHeaders | Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet. |
gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx"); //gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", "1NaMe5"); //gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataAndFormulasOnly, "1NaMe5"); //gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders);
GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx") 'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", "1NaMe5") 'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataAndFormulasOnly, "1NaMe5") 'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders)
System.Object
System.ValueType
System.Enum
GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags