poi使用excel模板导出数据，如何防止模板被修改

使用poi根据Excel模板填充数据

遇到的问题（模板文件会被修改 类似有缓存）

1. 通过 File方式创建Workbook时源模板文件会被修改，Workbook中会残留之前的数据，但模板文件 xls中并不会体现

    File excelFile = GetLocalFileUtil.getFile("temp.xlsx", "fileTemp");
    //通过file创建
    XSSFWorkbook workbook = XSSFWorkbookFactory.createWorkbook(excelFile)
   

   解决方案
   使用流创建Workbook

       File excelFile = GetLocalFileUtil.getFile("temp.xlsx", "fileTemp");
    //通过流创建workbook
    XSSFWorkbook workbook = XSSFWorkbookFactory.createWorkbook(new FileInputStream(excelFile));
    //=======================2007之下版本===========================//
    POIFSFileSystem poifsFileSystem = new POIFSFileSystem(excelFile);
    Workbook workbook = WorkbookFactory.create(poifsFileSystem);
   

模板样例

完整代码 只针对xssf

 public void generatorFile(String username, List<DataBean> dataBean){
        File excelFile = GetLocalFileUtil.getFile("temp.xlsx", "fileTemp");
        XSSFWorkbook workbook = null;
        FileOutputStream fileOutputStream = null;
        try {
            workbook = XSSFWorkbookFactory.createWorkbook(new FileInputStream(excelFile));

            CellStyle cellStyle = workbook.createCellStyle();
            cellStyle.setBorderBottom(BorderStyle.THIN);
            cellStyle.setBorderLeft(BorderStyle.THIN);
            cellStyle.setBorderTop(BorderStyle.THIN);
            cellStyle.setBorderRight(BorderStyle.THIN);
            cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
            cellStyle.setWrapText(true);

            Sheet sheet = workbook.getSheetAt(0);
            //处理title
            handlerTitle(currentMonth, username, sheet);
            //处理内容
            handlerRowData(sheet, cellStyle, dataBean);

            String filename = "%1$s-%2$d月任务明细表.xlsx";
            String formatFilename = String.format(filename, sysUserCard.getUsername(), currentMonth);
            String exportFilePath = FileUtil.getExportFilePath(excelUploadPath);
            File saveFile = FileUtil.getSaveFilePath(exportFilePath, formatFilename);
            fileOutputStream = new FileOutputStream(saveFile);
            workbook.write(fileOutputStream);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (workbook != null) {
                try {
                    workbook.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
            if (fileOutputStream != null) {
                try {
                    fileOutputStream.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }
    private void handlerTitle(int currentMonth, String username, Sheet sheet) {
        Row titleRow = sheet.getRow(0);
        Cell titleRowCell = titleRow.getCell(0);
        String titleContent = titleRowCell.getStringCellValue();
        String formatRowCellValue = String.format(titleContent, username, currentMonth,
                DateUtil.convertDateToString(new Date(), DateUtil.SIMPLE_DATE_TIME_PATTERN));
        titleRowCell.setCellValue(formatRowCellValue);
    }

    private void handlerRowData(Sheet sheet, CellStyle cellStyle, List<DataBean> dataBean) {
        Row headRow = sheet.getRow(1);
        int physicalNumberOfCells = headRow.getPhysicalNumberOfCells();
        for (int i = 0; i < taskCardList.size(); i++) {
            int lastNewRowNum = sheet.getLastRowNum();
            Row newRow = sheet.createRow(lastNewRowNum + 1);

            TaskCard taskCard = taskCardList.get(i);
            String taskId = taskCard.getParentId();
            Task task = daoTask.findOne("taskId", taskId);

            String projectId = task.getParentId();
            TaskProject taskProject = daoTaskProject.findOne("taskId", projectId);

            for (int cellIndex = 0; cellIndex < physicalNumberOfCells; cellIndex++) {
                Cell cell = newRow.createCell(cellIndex);
                cell.setCellStyle(cellStyle);

                Comment cellComment = headRow.getCell(cellIndex).getCellComment();
                String comment = "";
                if (cellComment != null) {
                    comment = cellComment.getString().toString().trim();
                }
                switch (comment) {
                    case "number":
                        cell.setCellValue(i + 1);
                        break;
                    case "projectName":
                        cell.setCellValue(dataBean.getProjectName());
                        break;
                    case "taskName":
                        cell.setCellValue(dataBean.getTaskName());
                        break;
                    case "subTaskName":
                        cell.setCellValue(dataBean.getSubTaskName());
                        break;
                    case "taskDesc":
                        cell.setCellValue(dataBean.getTaskDetail());
                        break;
                    case "taskType":
                        cell.setCellValue(dataBean.getTaskType());
                        break;
                    case "taskStatus":
                        cell.setCellValue(dataBean.getTaskStatus());
                        break;
                    case "startTime":
                        cell.setCellValue(dataBean.getStartTime());
                        break;
                }
            }
        }
    }