Represents the different ways to identify ranges within a workbook, including the sheet context.
Accepts:
ICellRange
A parsable string representing a range address, optionally including the sheet name (e.g., "Sheet1!A1:B2").
A partial IRange.FixableCoords object (specifying at least some of the range boundaries),
which may include the sheetName property to identify the sheet.
IWorkbook.CellAddress (representing a single cell within the workbook),
which may includes the sheetName property to identify the sheet.
Example
constaddress1: Address = "Sheet1!A1:B2"; // A1 notation with sheet name
Represents the different ways to identify ranges within a workbook, including the sheet context.
Accepts:
ICellRangestringrepresenting a range address, optionally including the sheet name (e.g., "Sheet1!A1:B2").IRange.FixableCoordsobject (specifying at least some of the range boundaries), which may include thesheetNameproperty to identify the sheet.IWorkbook.CellAddress(representing a single cell within the workbook), which may includes thesheetNameproperty to identify the sheet.