GrapeCity.Documents.Excel.UsedRangeType

UsedRangeType Enum

Specifies the feature type used to determine the used range of a worksheet.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

[Flags]
public enum UsedRangeType

<Flags>
Public Enum UsedRangeType

Examples

worksheet.Range["A1"].Value = "Data";
worksheet.Range["B2"].Interior.Color = Color.LightBlue;

// Get the used range that contains only data
IRange dataRange = worksheet.GetUsedRange(UsedRangeType.Data);

// Get the used range that contains data and style
IRange dataStyleRange = worksheet.GetUsedRange(
    UsedRangeType.Data | UsedRangeType.Style);

Fields

Name	Description
All	Specifies all data.
Axis	Specifies that the used range includes cells covered by chart axes.
Chart	Specifies that the used range includes cells covered by charts.
Comment	Specifies that the used range includes cells that have comments.
ConditionalFormatting	Specifies that the used range includes cells with conditional formatting rules.
Data	Specifies that the used range includes cells containing data (values or formulas).
DataValidation	Specifies that the used range includes cells with data validation rules.
Filter	Specifies that the used range includes cells covered by filters.
Hyperlink	Specifies that the used range includes cells that contain hyperlinks.
Merge	Specifies that the used range includes merged cells.
None	Specifies no feature type.
Picture	Specifies that the used range includes cells covered by pictures.
PivotTable	Specifies that the used range includes cells covered by pivot tables.
Shape	Specifies that the used range includes cells covered by shapes.
Slicer	Specifies that the used range includes cells covered by slicers.
Sort	Specifies that the used range includes cells covered by sort ranges.
Sparkline	Specifies that the used range includes cells that contain sparklines.
Style	Specifies that the used range includes cells with custom styles applied.
Table	Specifies that the used range includes cells covered by tables.