GrapeCity.Documents.Excel.IWorksheet.UsedRange

UsedRange Property

UsedRange

Returns the IRange object that represents the used range on the specified worksheet, its behavior is equivalent to GetUsedRange(UsedRangeType.Axis | UsedRangeType.Data | UsedRangeType.Comment | UsedRangeType.Style | UsedRangeType.Merge).

Declaration

IRange UsedRange { get; }

ReadOnly Property UsedRange As IRange

Examples

worksheet.Range["B2"].Value = "Used cell";
IRange usedRange = worksheet.UsedRange;
string address = usedRange.Address;