//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); Object data = new Object[][]{ {"Name", "City", "Birthday", "Eye color", "Weight", "Height"}, {"Richard", "New York", new GregorianCalendar(1968, 5, 8), "Blue", 67, 165}, {"Nia", "New York", new GregorianCalendar(1972, 6, 3), "Brown", 62, 134}, {"Jared", "New York", new GregorianCalendar(1964, 2, 2), "Hazel", 72, 180}, {"Natalie", "Washington", new GregorianCalendar(1972, 7, 8), "Blue", 66, 163}, {"Damon", "Washington", new GregorianCalendar(1986, 1, 2), "Hazel", 76, 176}, {"Angela", "Washington", new GregorianCalendar(1993, 1, 15), "Brown", 68, 145} }; worksheet.getRange("A1:F7").setValue(data); //three color scale. IColorScale threeColorScaleRule = worksheet.getRange("E2:E7").getFormatConditions().addColorScale(ColorScaleType.ThreeColorScale); threeColorScaleRule.getColorScaleCriteria().get(0).setType(ConditionValueTypes.LowestValue); threeColorScaleRule.getColorScaleCriteria().get(0).getFormatColor().setColor(Color.GetRed()); threeColorScaleRule.getColorScaleCriteria().get(1).setType(ConditionValueTypes.Percent); threeColorScaleRule.getColorScaleCriteria().get(1).setValue(30); threeColorScaleRule.getColorScaleCriteria().get(1).getFormatColor().setColor(Color.GetYellow()); threeColorScaleRule.getColorScaleCriteria().get(2).setType(ConditionValueTypes.HighestValue); threeColorScaleRule.getColorScaleCriteria().get(2).getFormatColor().setColor(Color.GetGreen()); //save to an excel file workbook.save("CreateThreeColorScaleRule.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val data = arrayOf(arrayOf("Name", "City", "Birthday", "Eye color", "Weight", "Height"), arrayOf("Richard", "New York", GregorianCalendar(1968, 5, 8), "Blue", 67, 165), arrayOf("Nia", "New York", GregorianCalendar(1972, 6, 3), "Brown", 62, 134), arrayOf("Jared", "New York", GregorianCalendar(1964, 2, 2), "Hazel", 72, 180), arrayOf("Natalie", "Washington", GregorianCalendar(1972, 7, 8), "Blue", 66, 163), arrayOf("Damon", "Washington", GregorianCalendar(1986, 1, 2), "Hazel", 76, 176), arrayOf("Angela", "Washington", GregorianCalendar(1993, 1, 15), "Brown", 68, 145)) worksheet.getRange("A1:F7").value = data //three color scale. val threeColorScaleRule = worksheet.getRange("E2:E7").formatConditions.addColorScale(ColorScaleType.ThreeColorScale) threeColorScaleRule.colorScaleCriteria.get(0).type = ConditionValueTypes.LowestValue threeColorScaleRule.colorScaleCriteria.get(0).formatColor.color = Color.GetRed() threeColorScaleRule.colorScaleCriteria.get(1).type = ConditionValueTypes.Percent threeColorScaleRule.colorScaleCriteria.get(1).value = 30 threeColorScaleRule.colorScaleCriteria.get(1).formatColor.color = Color.GetYellow() threeColorScaleRule.colorScaleCriteria.get(2).type = ConditionValueTypes.HighestValue threeColorScaleRule.colorScaleCriteria.get(2).formatColor.color = Color.GetGreen() //save to an excel file workbook.save("CreateThreeColorScaleRule.xlsx")