//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IRange range = worksheet.getRange("A5:B7"); // cell count is 6. int cellcount = range.getCount(); // cell count is 6. int cellcount1 = range.getCells().getCount(); // row count is 3. int rowcount = range.getRows().getCount(); // column count is 2. int columncount = range.getColumns().getCount();
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val range = worksheet.getRange("A5:B7") // cell count is 6. val cellcount = range.count // cell count is 6. val cellcount1 = range.cells.count // row count is 3. val rowcount = range.rows.count // column count is 2. val columncount = range.columns.count