Area
| API | Description | Example |
|---|---|---|
| Range.Areas | Property that returns the area management object of the specified range | let range = instance.Application.ActiveSheet.UsedRange; let areas = range.Areas; |
| Areas.Count | Property that returns the number of areas in the specified range | let application = instance.Application; let a1b2Andc3d4Range = application.Union(application.Range("A1:B2"),application.Range("C3:D4")); console.log(a1b2Andc3d4Range.Areas.Count); // Outputs 2 to console |
| Areas.Item | Function that returns a range object with the area corresponding to a specific index among the areas of the specified range | let application = instance.Application; let a1b2Andc3d4Range = application.Union(application.Range("A1:B2"), application.Range("C3:D4")); let a1b2Range = a1b2Andc3d4Range.Areas.Item(1); |
Related Features
Spreadsheet Basic Functions , Engine Global Management , Integrated Document Management , Integrated Document , Sheet Management , Sheet , Range , Engine Object Common