Programmer's Reference > ExcelApplication API > Range

The Range Object

A Range object represents a range in a workbook. A range is a collection of areas. An area is a rectangular collection of cells. The areas in a range may be non-adjacent, and a range can include areas in different worksheets.

To create a Range (without a name), call one of the following methods:

• Workbook.CreateRange(rangeFormula)
• Worksheet.CreateRange(rangeFormula)
• Worksheet.CreateRangeOfColumns(firstCol, numCols)
• Worksheet.CreateRangeOfRows(int firstRow, int numRows)

If a range is named, it will be accessible when the workbook is opened in Microsoft Excel. To create a named range, call one of the following methods:

• Workbook.CreateNamedRange(rangeFormula, rangeName)
• Worksheet.CreateNamedRange(firstRow, firstColumn, numRows, numColumns, rangeName)
• Worksheet.CreateNamedRange(rangeFormula, rangeName)

Examples:

ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
wb.Worksheets.CreateWorksheet("Sheet2");
Range rng = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5");

Dim xla As New ExcelApplication()
Dim wb As Workbook = xla.Create()
wb.Worksheets.CreateWorksheet("Sheet2")
Dim rng As Range = wb.CreateRange("=Sheet1!A1:A3, Sheet2!A2:C5")

Range Properties

Range Methods

Copyright 2006 © SoftArtisans, Inc. All Rights Reserved.