// 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); worksheet.getColumns().get(2).autoFit(); //data bar rule. IDataBar dataBar = worksheet.getRange("E2:E7").getFormatConditions().addDatabar(); dataBar.getMinPoint().setType(ConditionValueTypes.LowestValue); dataBar.getMinPoint().setValue(null); dataBar.getMaxPoint().setType(ConditionValueTypes.HighestValue); dataBar.getMaxPoint().setValue(null); dataBar.setBarFillType(DataBarFillType.Gradient); dataBar.getBarColor().setColor(Color.GetGreen()); dataBar.setDirection(DataBarDirection.Context); dataBar.getAxisColor().setColor(Color.GetRed()); dataBar.setAxisPosition(DataBarAxisPosition.Automatic); dataBar.getNegativeBarFormat().setBorderColorType(DataBarNegativeColorType.Color); dataBar.getNegativeBarFormat().getBorderColor().setColor(Color.GetBlue()); dataBar.getNegativeBarFormat().setColorType(DataBarNegativeColorType.Color); dataBar.getNegativeBarFormat().getColor().setColor(Color.GetPink()); dataBar.setShowValue(false); // Save to an excel file workbook.save("CreateDatabBarRule.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 worksheet.columns[2].autoFit(); //data bar rule. val dataBar = worksheet.getRange("E2:E7").formatConditions.addDatabar() dataBar.minPoint.type = ConditionValueTypes.LowestValue dataBar.minPoint.value = null dataBar.maxPoint.type = ConditionValueTypes.HighestValue dataBar.maxPoint.value = null dataBar.barFillType = DataBarFillType.Gradient dataBar.barColor.color = Color.GetGreen() dataBar.direction = DataBarDirection.Context dataBar.axisColor.color = Color.GetRed() dataBar.axisPosition = DataBarAxisPosition.Automatic dataBar.negativeBarFormat.borderColorType = DataBarNegativeColorType.Color dataBar.negativeBarFormat.borderColor.color = Color.GetBlue() dataBar.negativeBarFormat.colorType = DataBarNegativeColorType.Color dataBar.negativeBarFormat.color.color = Color.GetPink() dataBar.showValue = false // Save to an excel file workbook.save("CreateDatabBarRule.xlsx")