This topic lists the Excel open and save flags that can be used when importing or exporting an Excel-formatted file.
| Enumeration |
Description |
| public enum ExcelOpenFlags |
Specifies what part of the Excel-compatible file to load into the spreadsheet. |
| NoFlagsSet = 0 |
Opens the spreadsheet from the Excel-compatible file with no special options. |
| DataOnly = 1 |
Loads only the data from the Excel-compatible file into the spreadsheet. |
| DataAndFormulasOnly = 3 |
Loads formulas from the Excel-compatible file into the spreadsheet. |
| RowHeaders = 4 |
Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet. |
| ColumnHeaders = 8 |
Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet. |
| RowAndColumnHeaders = 12 |
Loads row headers from frozen columns and column headers from frozen rows. |
| DoNotRecalculateAfterLoad = 1024 |
Avoids recalculation after loading the Excel-compatible file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate()) |
| Enumeration |
Description |
| public enum ExcelSaveFlags |
Specifies what part of the spreadsheet to export to an Excel-compatible file. |
| NoFlagsSet = 0 |
Saves the spreadsheet to the Excel-compatible file with no special options. |
| NoFormulas = 1 |
Saves the displayed data, but not the formulas, to the Excel-compatible file. |
| SaveCustomRowHeaders = 2 |
Saves the custom row headers to the Excel-compatible file. |
| SaveCustomColumnHeaders = 4 |
Saves the custom column headers to the Excel-compatible file. |
| SaveAsFiltered = 8 |
Saves the filtered row results to the Excel-compatible file. |
| SaveBothCustomRowAndColumnHeaders = 6 |
Saves both the custom row headers and the custom column headers to the Excel-compatible file. |
| SaveAsViewed = 136 |
Saves the spreadsheet as viewed to the Excel-compatible file. |
| DataOnly = 32 |
Saves only the data to the Excel-compatible file. |
| AutoRowHeight = 4096 |
The default row height is not saved. Excel automatically determines row heights based on the largest font that is set in each row. |