//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IRange range = worksheet.getRange("A5:B7"); //set value for cell A7. range.getCells().get(4).setValue("A7"); //cell is B6 range.getCells().get(1, 1).setValue("B6"); //row count is 3 and range is A6:B6. int rowCount = range.getRows().getCount(); String row = range.getRows().get(1).toString(); //set interior color for row range A6:B6. range.getRows().get(1).getInterior().setColor(Color.GetLightBlue()); //column count is 2 and range is B5:B7. int columnCount = range.getColumns().getCount(); String column = range.getColumns().get(1).toString(); //set values for column range B5:B7. range.getColumns().get(1).getInterior().setColor(Color.GetLightSkyBlue()); //entire rows are from row 5 to row 7 String entirerow = range.getEntireRow().toString(); //entire columns are from column A to column B String entireColumn = range.getEntireColumn().toString(); //save to an excel file workbook.save("AccessCellsRowsColumns.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val range = worksheet.getRange("A5:B7") //set value for cell A7. range.cells.get(4).value = "A7" //cell is B6 range.cells.get(1, 1).value = "B6" //row count is 3 and range is A6:B6. val rowCount = range.rows.count val row = range.rows.get(1).toString() //set interior color for row range A6:B6. range.rows.get(1).interior.color = Color.GetLightBlue() //column count is 2 and range is B5:B7. val columnCount = range.columns.count val column = range.columns.get(1).toString() //set values for column range B5:B7. range.columns.get(1).interior.color = Color.GetLightSkyBlue() //entire rows are from row 5 to row 7 val entirerow = range.entireRow.toString() //entire columns are from column A to column B val entireColumn = range.entireColumn.toString() //save to an excel file workbook.save("AccessCellsRowsColumns.xlsx")