// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //Range A1's displaying color is table style worksheet.getTables().add(worksheet.getRange("A1:E5"), true); Color color_A1 = worksheet.getRange("A1").getDisplayFormat().getInterior().getColor(); //Range A1's displaying color will be cell style, yellow. worksheet.getRange("A1").getInterior().setColor(Color.GetYellow()); Color color_A1_1 = worksheet.getRange("A1").getDisplayFormat().getInterior().getColor(); //Range A1's displaying color will be conditional format style, green. IFormatCondition condition = (IFormatCondition) worksheet.getRange("A1").getFormatConditions().add(FormatConditionType.NoBlanksCondition); condition.getInterior().setColor(Color.GetGreen()); Color color_A1_2 = worksheet.getRange("A1").getDisplayFormat().getInterior().getColor(); // Save to an excel file workbook.save("GetDisplayFormat.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) //Range A1's displaying color is table style worksheet.tables.add(worksheet.getRange("A1:E5"), true) val color_A1 = worksheet.getRange("A1").displayFormat.interior.color //Range A1's displaying color will be cell style, yellow. worksheet.getRange("A1").interior.color = Color.GetYellow() val color_A1_1 = worksheet.getRange("A1").displayFormat.interior.color //Range A1's displaying color will be conditional format style, green. val condition = worksheet.getRange("A1").formatConditions.add(FormatConditionType.NoBlanksCondition) as IFormatCondition condition.interior.color = Color.GetGreen() val color_A1_2 = worksheet.getRange("A1").displayFormat.interior.color // Save to an excel file workbook.save("GetDisplayFormat.xlsx")