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

C#

public string CellRange { get; set; }

VB.NET

Public Property CellRange As String

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.

C#

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

VB.NET

Dim worksheetSettings As New ExcelWorksheetSettings()
worksheetSettings.CellRange = "Sheet1!A1:F20"

Related GitHub Examples

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.

VB.NET

winforms-dashboard-bind-pie-item-to-data-in-code/VB/Dashboard_CreatePies/Form1.vb#L26

importSettings.WorksheetName = "Data"
importSettings.CellRange = "A1:L100"
options.ImportSettings = importSettings