Advertisement

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)

还没有任何评论哟~