Public Static Fields
  MaxColumns | Maximum number of columns in ExcelWorksheet. |
| MaxRows | Maximum number of rows in ExcelWorksheet. |
| MaxXlsCellStyles | Maximum number of user-defined cell styles in XLS (BIFF8) file. |
| MaxXlsColors | Maximum number of colors in XLS (BIFF8) file. |
| MaxXlsColumns | Maximum number of columns in XLS (BIFF8) file. |
| MaxXlsRows | Maximum number of rows in XLS (BIFF8) file. |
Public Static Methods
 SupportsType | Gets a value indicating whether the objects of specified type can be assigned to ExcelCell.Value property. |
Public Instance Constructors
|
ExcelFile Constructor
|
Initializes an empty (no worksheets) instance of the ExcelFile class. |
Public Instance Properties
 CsvParseNumbersDuringLoad | Gets or sets whether LoadCsv() methods will try to convert text values to numbers. |
| DefaultFontName | Gets or sets name of the default font used in the workbook. |
| DefaultFontSize | Gets or sets default font size. |
| DefinedNames | Gets the collection of defined names that are not directly related with one cell range. Supported in XLSX only. |
| DelayFormulaParse | Delays formula parsing until one of SaveXls methods is called. |
| GroupMethodsAffectedCellsLimit | Maximum number of affected cells in group set methods. |
| Protected | Gets or sets the workbook protection flag. |
| RowColumnResolutionMethod | Gets or sets the CellStyle resolution method. |
| Use1904DateSystem | Gets or sets whether 1904 date system is used. |
| Worksheets | Collection of all worksheets (ExcelWorksheet) in a workbook. |
Public Instance Methods
| ClosePreservedXlsx | Closes preserved XLSX file handle if needed (XlsxOptions.PreserveKeepOpen was used with ExcelFile.LoadXlsx(string,XlsxOptions) method). (NET30 and NET 35 only) |
| LoadCsv | Overloaded. Loads the existing CSV file or stream. |
| LoadXls | Overloaded. Loads the existing XLS file or stream. |
| LoadXlsx | Overloaded. Loads the existing XLSX file or stream. (NET30 and NET35 only) |
| LoadXlsxFromDirectory | Loads all parts of XLSX file as separate files from input directory. |
| SaveCsv | Overloaded. Saves all data to a new file or stream in CSV format. |
| SaveHtml | Overloaded. Saves the data from used range of the active worksheet to a new file or XmlTextWriter in HTML format. |
| SaveXls | Overloaded. Saves all data to a file or stream in XLS format. |
| SaveXlsx | Overloaded. Saves all data to a file or stream in XLSX format. (NET30 and NET35 only) |
| SaveXlsxToDirectory | Saves all parts of XLSX file as separate files to output directory. |
Public Instance Events
 IoWarning | Fired for unexpected situations when reading or writing XLS / CSV files. |
| LimitNear | Occurs when the size of XLS / CSV file in reading / writing is near GemBox.Spreadsheet Free limit. (Free version only) |
| LimitReached | Occurs when the size of XLS / CSV file in reading / writing is above GemBox.Spreadsheet Free limit. (Free version only) |
See Also
ExcelFile Class | GemBox.Spreadsheet Namespace | ExcelWorksheet