//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); // set interior color for area1 A5:B7. IRange area1 = worksheet.getRange("A5:B7, C3, H5:N6").getAreas().getArea(0); area1.getInterior().setColor(Color.GetPink()); // set interior color for area2 C3. IRange area2 = worksheet.getRange("A5:B7, C3, H5:N6").getAreas().getArea(1); area2.getInterior().setColor(Color.GetLightGreen()); // set interior color for area3 H5:N6. IRange area3 = worksheet.getRange("A5:B7, C3, H5:N6").getAreas().getArea(2); area3.getInterior().setColor(Color.GetLightBlue()); //save to an excel file workbook.save("AccessEachAreaOfRange.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) // set interior color for area1 A5:B7. val area1 = worksheet.getRange("A5:B7, C3, H5:N6").areas.getArea(0) area1.interior.color = Color.GetPink() // set interior color for area2 C3. val area2 = worksheet.getRange("A5:B7, C3, H5:N6").areas.getArea(1) area2.interior.color = Color.GetLightGreen() // set interior color for area3 H5:N6. val area3 = worksheet.getRange("A5:B7, C3, H5:N6").areas.getArea(2) area3.interior.color = Color.GetLightBlue() //save to an excel file workbook.save("AccessEachAreaOfRange.xlsx")