Get Cells Range
Contents
[
Hide
]
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.
- Cells.getMaxDisplayRange()
- Cells.getMaxRow()
- Cells.getMaxDataRow()
- Cells.getMaxColumn()
- Cells.getMaxDataColumn()
Get Cells Range using Aspose.Cells
This example shows how to:
- Create a workbook.
- Add data to cells in the first worksheet.
- Get Cells Range.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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()); |