Get Cells Range

Possible Usage Scenarios

When you only need to manipulate some data on the worksheet, you need to know the data range of the entire worksheet. Aspose.Cells offers this feature. Aspose.Cells provides the following properties and methods to help you achieve your goals.

Get Cells Range using Aspose.Cells

This example shows how to:

  1. Create a workbook.
  2. Add data to cells in the first worksheet.
  3. Get Cells Range.

//Instantiating an Workbook object
Workbook workbook = new Workbook();
//Obtaining the reference of the newly added worksheet
Worksheet ws = workbook.getWorksheets().get(0);
Cells cells = ws.getCells();
//Setting the value to the cells
Cell cell = cells.get("A1");
cell.putValue("Fruit");
cell = cells.get("B1");
cell.putValue("Count");
cell = cells.get("C1");
cell.putValue("Price");
cell = cells.get("A2");
cell.putValue("Apple");
cell = cells.get("A3");
cell.putValue("Mango");
cell = cells.get("A4");
cell.putValue("Blackberry");
cell = cells.get("A5");
cell.putValue("Cherry");
cell = cells.get("B2");
cell.putValue(5);
cell = cells.get("B3");
cell.putValue(3);
cell = cells.get("B4");
cell.putValue(6);
cell = cells.get("B5");
cell.putValue(4);
cell = cells.get("C2");
cell.putValue(5);
cell = cells.get("C3");
cell.putValue(20);
cell = cells.get("C4");
cell.putValue(30);
cell = cells.get("C5");
cell.putValue(60);
cell = cells.get("E10");
Style temp = workbook.createStyle();
temp.getFont().setColor(Color.getRed());
cell.setStyle(temp);
// Get max display range of worksheet
Range range = cells.getMaxDisplayRange();
//get maximum row index of cell which contains data.
System.out.println(cells.getMaxRow());
//get maximum row index of cell which contains data or style.
System.out.println(cells.getMaxDataRow());
//get maximum column index of cell which contains data.
System.out.println(cells.getMaxColumn());
//get maximum column index of cell which contains data or style.
System.out.println(cells.getMaxDataColumn());