Skip to main content

ExcelWorksheetSettings.CellRange Property

Gets or sets the cell range from which data is imported.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

public string CellRange { get; set; }

Property Value

Type Description
String

A String value that specifies the cell range from which data is imported.

Remarks

The following example shows how to select the A1:F20 range of cells located on the Sheet1 worksheet using the CellRange property.

ExcelWorksheetSettings worksheetSettings = new ExcelWorksheetSettings();
worksheetSettings.CellRange = "Sheet1!A1:F20";

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the CellRange property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also