NEW3.04.03 · Released 1 February 2022
NEWfinPOWER Connect
Released in
3.04.03
1 February 2022
- Opened3 Dec 2021
- Closed6 Dec 2021
- Released1 Feb
Article 18806
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