Get Row and Column Count

When you have a worksheet with bulk data, it becomes cumbersome to manually fetch the number of rows and columns.

DsExcel Java allows users to quickly get the row and column count of the specific areas or all the areas in a range.

The fields and methods of the IRange interface represent the cell count of all the areas in a range.

Refer to the following example code in order to get the row count and column count in a worksheet.

IRange range = worksheet.getRange("A5:B7, C3, H5:I6");
        
// Cell count is 11. All areas cell count
int cellcount = range.getCount();
System.out.println(cellcount);
        
// Cell count is 11. All areas cell count
int cellcount1 = range.getCells().getCount();
System.out.println(cellcount1);
        
// Row count is 3. First area's row count
int rowcount = range.getRows().getCount();
System.out.println(rowcount);
        
// Column count is 2. First area's column count
int columncount = range.getColumns().getCount();