我现在想修改导出Excel的部分界面。
下图是现在的界面,左边的使用说明是写死的,数据源是动态生成的,我现在只需要修改使用说明就好了。
这个是修改后变成的样子
部分后端代码
private ExcelExportprepayExport(List list) { ExcelExport excelExport = new ExcelExport (); excelExport.setSheetName(SeaxConstants.EXCEL_SHEET_NAME_COMPANY); excelExport.setHeaders(HEADERS); excelExport.setGetterMethodName(GETTER_METHOD_NAME); excelExport.setColumnWidth(COLUMN_WIDTH); excelExport.setDataset(list); excelExport.setList(InventoryExcelDescribe.getList());//得到使用说明的界面 return excelExport; }
InventoryExcelDescribe类:
ONE(1,"xxxx"), TWO(2,"xxxx"), THREE(3,"xxx"), FOUR(4,"xxx"), FIVE(5,"xxx"), SIX(6,"xxx"), SEVEN1(7," xxx黄色标示提醒"), SEVEN2(8," xxx绿色标示提醒;"), SEVEN3(9," xxx红色标示提醒"), SEVEN4(10," xxx"), SEVEN5(11," xxx"), EIGHT(12,"xxx"), NINE(13,"xxx"); private String name; private int code; public static List getList() { Listlist = new ArrayList<>(); for (InventoryExcelDescribe em : InventoryExcelDescribe.values()) { EnumObj obj = new EnumObj(); obj.setId(em.getCode()); obj.setName(em.getName()); list.add(obj); } return list; }
那么我现在这么在原来的基础上加上3个单元格(7.8.9右边的单元格),且各自都有背景色(固定位置的)?
推荐一个框架 EasyPoi 看看能不能解决