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 ISExcelCellRange
If Worksheet.GetUsedRangeInformation(CellRange) Then
finBL.DebugWatch(CellRange)
Else
' Error
End If
The following functions have been obsoleted and newer alternative functions added that use ISExcelCellRange:
- ISExcelWorksheet
- GetNamedRangeInformation
- GetUsedRangeInformation
- SetPrintArea