需要将统计数据填充到指定的Excel模板中
public void writeExcelFile(LocalDate start, LocalDate end, String filename) {
File file = new File("files/report_Demo.xlsx");
XSSFWorkbook workbook = null;
try {
FileInputStream fileInputStream = new FileInputStream(file);
workbook = new XSSFWorkbook(fileInputStream);
} catch (Exception e) {
}
//查找到指定的sheet
XSSFSheet sheet = workbook.getSheet("抓取数据展示");
sheet.setForceFormulaRecalculation(true);
Map<String, List<StatInfo>> sourceCompares = getCompare(start, end);
Map<String, String> catchMap = new HashMap<>();
for (Map.Entry<String, List<StatInfo>> entry : sourceCompares.entrySet()) {
String site = entry.getKey();
int rowNum = 0;
//判断指定数据存放到指定的行数
switch (site) {
case "weixin":
rowNum =