Java 导出 Excel 时，如何设置条件格式数据条？-灵析社区
销售经理537使用Java 导出一个Excel文件，如何给单元格设置条件格式数据条样式？
一只tomatoo可以尝试GcExcel Java 组件，其支持条件格式的数据条，具体代码如下：
更多GcExcel支持的条件格式可以参考："Excel API Library for Java - Sample Browser | GrapeCity Documents | Conditional Formatting" (https://link.segmentfault.com/?enc=GcWKK8Ysq%2FcXPVDQqSyoxg%3D%3D.VUw911mgeg5jWegcB4KdoSCKI5YngmNUygzIEI%2BZzBJl8ON3LXNdtZdA8kmdfpPMKu1HFq0cmmmDMqucn8tPKGMO9Vgli4I8ExwSp9irnSH2gIf3ldW2wQubWbUIH68Y)
public void ConditionFormatDataBar(){
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);
//添加数据条规则
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);
//保存为Excel文件
workbook.save("output/CreateDatabBarRule.xlsx");
}