# Get Row and Column Count

With DsExcel, you can quickly get the row and column count of the specific areas or all the areas in a range.

## Content





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](/document-solutions/java-excel-api/api/online/com/grapecity/documents/excel/IRange.html) 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.

```Java
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();
```