本人最近需要每天统计数据表,并每周一发送统计结果的邮件,所以写了个springboot老自动完成工作。项目地址为:https://github.com/707293891/springboot
其中某些统计数据需要特殊标记:红色显示。
如图:模版如下
但是需要在某一处特殊显示为红色:如图
现在写出实现过程:
利用jxls的区域监听器实现.
Transformer transformer = TransformerFactory.createTransformer(getFileInputStream(), new FileOutputStream( new File( Thread.currentThread().getContextClassLoader(). getResource("excelTemplates/result").getFile()+"/result.xls"))); XlsArea xlsArea=new XlsArea("Sheet1!A1:F3",transformer); XlsArea employeeArea = new XlsArea("Sheet1!A3:F3", transformer); employeeArea.addAreaListener(new SimpleAreaListener(employeeArea)); EachCommand eachCommand=new EachCommand("item","items",employeeArea); xlsArea.addCommand("A3:F3", eachCommand); Context context = new Context(); Map map=new HashMap(); // map.put("list",getData()); map.put("week",CalendarUtil.getWeekNum()); map.put("month"