Article Details
| Id: | 18806 |
| Product: | finPOWER Connect |
| Type: | NEW |
| Version: | 3.04.03 |
| Opened: | 03/12/2021 |
| Closed: | 06/12/2021 |
| Released: | 01/02/2022 |
| Job: | J027954 |
Excel Workbook functions; added new ISExcelCellRange object
Added support for Excel Cell Ranges via the ISExcelCellRange object.
This provides a better alternative to passing around the first column and row and last column and row or Cell References (top/left and bottom/right) in the format "A1" etc.
For example, this is used in the new ISExcelWorksheet.Sort and updated GetUsedRangeInformation functions, see below for an example:
Dim CellRange As ISExcelCellRangeIf Worksheet.GetUsedRangeInformation(CellRange) ThenfinBL.DebugWatch(CellRange)Else' ErrorEnd If
The following functions have been obsoleted and newer alternative functions added that use ISExcelCellRange:
- ISExcelWorksheet
- GetNamedRangeInformation
- GetUsedRangeInformation
- SetPrintArea