Type Alias RangesAddress

RangesAddress:
    | ICellRanges
    | string
    | IWorkbook.RangeAddress
    | readonly IWorkbook.RangeAddress[]

Represents the different ways to identify multiple ranges within a workbook, including their sheet context.

Accepts:

ICellRanges
A parsable string containing multiple range addresses, optionally including sheet names, separated by commas (e.g., "Sheet1!A1:B2,Sheet2!C3:D4").
An array of IWorkbook.RangeAddress objects, each representing a single range within a workbook.

Example

const address1: IWorkbook.RangesAddress = "Sheet1!A1:B2,Sheet2!C3:D4"; // String with multiple ranges and sheet names

Remarks

This extends ICellRanges.Address to support multiple values.