Access Cells, Rows and Columns in a Range

You can access cells, rows and columns in a range by using the getCells method, the getRows method and the getColumns method of the IRange interface.

Refer to the following example code in order to access cells, rows and columns in a worksheet.

// Create a new workbook and fetch the worksheet
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().add();
        
// Access Range and set A1:B5, C2:E4's interior color
worksheet.getRange("A1:B5, C2:E4").getInterior().setColor(Color.GetGreen());
        
// Access Rows and set row 1's font size
worksheet.getRows().get(0).getFont().setSize(20);
        
// Access Columns and delete column C
worksheet.getColumns().get(2).delete();
        
// Access Cells and set A1's value
worksheet.getCells().get(0).setValue(1);