JAVA开发用于Excel模板填充的应用
发布时间
阅读量:
阅读量
需将相关统计数值输入至预设的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 = getCom
全部评论 (0)
还没有任何评论哟~
