Syncfusion.XlsIO.Base
Example 


UsedCells Property

Gets all not empty or accessed cells. Read-only.
Syntax
'Declaration
 
ReadOnly Property UsedCells As IRange()
'Usage
 
Dim instance As IWorksheet
Dim value() As IRange
 
value = instance.UsedCells
IRange[] UsedCells {get;}
Remarks
WARNING: This property creates Range object for each cell in the worksheet and creates new array each time user calls to it. It can cause huge memory usage especially if called frequently.
Example
The following code illustrates how to get the used cells range of a sheet.
IWorksheet sheet = workbook.Worksheets[0];
IRange[] usedCellsRange = sheet.UsedCells;
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also