Office Version On Windows (Microsoft 365)
Version 2102 (Build 13801.20738)
Office Version On Windows Volume Licensed
Office 2021: Version 2102 (Build 13801.20738)
Office Version On Mac
16.50
Office Version On iPad
16.50
Office on the web
Supported
The following is a curated collection of Excel methods integrated into VXL Live. These methods are crucial for interacting with Excel workbooks and enhancing functionality. Each method is associated with a specific class and corresponds to a particular version of the Excel API.
| Methods | Class | Version |
|---|---|---|
getActiveWorksheet() |
WorksheetCollection |
ExcelApi 1.1 |
getRange() |
Worksheet |
ExcelApi 1.1 |
getAbsoluteResizedRange() |
Range |
ExcelApi 1.7 |
getUsedRange() |
Worksheet |
ExcelApi 1.1 |
autofitColumns() |
RangeFormat |
ExcelApi 1.2 |
getCell() |
Worksheet |
ExcelApi 1.1 |
getDataBodyRange() |
Table |
ExcelApi 1.1 |
delete() |
Range |
ExcelApi 1.1 |
add() |
TableRowCollection |
ExcelApi 1.1 (single row), |
| ExcelApi 1.4 (multiple rows), | ||
insertWorksheetsFromBase64() |
Workbook |
ExcelApi 1.13 |
getRanges() |
Worksheet |
ExcelApi 1.9 |
Note: The topmost version of the method insertWorksheetsFromBase64() is in API Excel set is ExcelApi 1.13
See overview from Microsoft here