[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.IWorksheet.GetUsedRange

GetUsedRange Method

GetUsedRange(UsedRangeType)

Gets the used range.

Declaration
IRange GetUsedRange(UsedRangeType type = UsedRangeType.All)
Function GetUsedRange(Optional type As UsedRangeType = UsedRangeType.All) As IRange
Parameters
Type Name Description
UsedRangeType type

The feature type.
Returns
Type Description
IRange

The used range for the specified feature type.
Examples
worksheet.Range["B2"].Value = "Used cell";
IRange usedRange = worksheet.GetUsedRange(UsedRangeType.Data);
string address = usedRange.Address;