| Name | Description | |
|---|---|---|
| Calculate | Performs a calculation of the entire Workbook. | |
| CellColumnRowToReference | Takes a Column and Row index and returns the corresponding Cell Reference. | |
| CellReferenceToColumnRow | Takes a Cell Reference string and returns the Column and Row indexes. | |
| ColumnIndexToColumnName | Converts a one-based Column index to the corresponding Column Name. | |
| ColumnNameToColumnIndex | Converts a Column Name to a one-based Column index. | |
| GetAsCsvString | Get the first Worksheet in the Excel Workbook as a CSV String. | |
| IsSupportedSaveFileExtension | Indicates whether the file extension is a supported file type that can be saved. | |
| IsWorksheetNameValid | ||
| Open | Opens an Excel Workbook or compatible file, e.g. CSV file. | |
| OpenFromByteArray | Loads an Excel Workbook from a byte array. | |
| Prints the Excel Workbook. | ||
| Save | Save the Excel Workbook to a File. Note, the format of the file is determined by the file extension - also see Remarks. | |
| SavePdfToByteArray | Saves the Excel Workbook to a Byte Array in PDF format. | |
| SaveTiffToByteArray | Saves the Workbook to a Byte Array in Tiff image format. | |
| SaveXlsxToByteArray | Saves the Excel Workbook to a Byte Array in Xlsx format. |
| Name | Description | |
|---|---|---|
| ActiveWorksheet | The Active Worksheet. | |
| CalculationOptions Read-Only | Excel calculation options. | |
| Filename Read-Only | The Filename of the Excel Workbook opened or last saved. | |
| FontsFolder | The folder where private Fonts are stored. | |
| Gembox_ExcelFile Read-Only System Use Only | ||
| SupportedOpenFileFilterList Read-Only | ||
| Worksheets Read-Only | The Worksheets in the open Excel Workbook. |