コード例 #1
0
 @RemoteMethod
 public FileTransfer downloadFile(String id, HttpServletRequest request) {
   TemplateShareGroupDetail shareGroupDetail = templateShareGroupDetailDaoImpl.findById(id);
   String path =
       formTemplateService.downLoadFilePath(
               shareGroupDetail.getAccount(), shareGroupDetail.getCreate_date())
           + "/"
           + shareGroupDetail.getFilePath();
   return FileDownLoadUtils.downloadFile(path, shareGroupDetail.getFileName());
 }
コード例 #2
0
  /**
   * saveMerage 合并多个excel文件
   *
   * @param args
   * @return void
   * @exception
   */
  @RemoteMethod
  public void saveMerage(List<String> args, String templateFileId) {
    HSSFWorkbook hSSFtargetWorkbook = new HSSFWorkbook();
    // XSSFWorkbook xSSFtargetWorkbook = new XSSFWorkbook();
    Workbook workbook = null;
    FileOutputStream out = null;
    InputStream sourceStream = null;
    try {
      // 保存上传的合并文件
      TemplateFile templateFile = templateFileDaoImpl.findById(templateFileId);
      String uuid = UUID.randomUUID().toString();
      String templateFilePath = getFilePath(templateFile);
      String uploadFilePath =
          formTemplateService.getUploadFilePath(null, BusinessConstant.FORM_UPLOAD)
              + "/"
              + uuid
              + FileUploadUtils.getFileType(templateFilePath);
      templateFile.setGroupFileName(templateFile.getFileName());
      templateFile.setGroupFilePath(uuid + FileUploadUtils.getFileType(templateFilePath));
      templateFileDaoImpl.saveOrUpdate(templateFile);

      for (String detaiId : args) {
        TemplateShareGroupDetail templateShareGroupDetail =
            templateShareGroupDetailDaoImpl.findById(detaiId);
        String filePath =
            formTemplateService.downLoadFilePath(
                    templateShareGroupDetail.getAccount(),
                    templateShareGroupDetail.getCreate_date())
                + "/"
                + templateShareGroupDetail.getFilePath();
        sourceStream = new FileInputStream(filePath); // 每个实例的文件路径
        workbook = WorkbookFactory.create(sourceStream);
        if (".xls".equals(FileUploadUtils.getFileType(templateShareGroupDetail.getFilePath()))
            || ".et".equals(FileUploadUtils.getFileType(templateShareGroupDetail.getFilePath()))) {
          out = new FileOutputStream(new File(uploadFilePath)); // 合并后的文件路径
          PoiUtils.copySheet2003(
              hSSFtargetWorkbook.createSheet(
                  templateShareGroupDetail.getAccount().getPerson().getName()),
              (HSSFSheet) workbook.getSheetAt(0),
              hSSFtargetWorkbook,
              (HSSFWorkbook) workbook,
              true,
              true);
          hSSFtargetWorkbook.write(out);
        }
        // 由于金格office编辑器在编辑07版本的excel时会将其内在格式转换为03版本,故poi无法将以.xlsx为后缀的excel读取为XSSFWorkBook对象,此功能暂注释
        // else if
        // (".xlsx".equals(getFileType(templateShareGroupDetail.getFilePath())))
        // {// 2007
        // out = new FileOutputStream(new File("d:\\hhh2.xlsx"));
        // PoiUtils.copySheet2007(xSSFtargetWorkbook.createSheet(templateShareGroupDetail.getAccount().getPerson().getName()),
        // (XSSFSheet) workbook.getSheetAt(0), xSSFtargetWorkbook,
        // (XSSFWorkbook) workbook, true);
        // xSSFtargetWorkbook.write(out);
        // }
        else throw new BusinessException(ERR_COMPONENT + "101");
      }
      templateFileLogService.addOperationLog(
          templateFile, BusinessConstant.OPERATION_SHARE_GROUP_MODIFY, null);
    } catch (Exception e) {
      e.printStackTrace();
      throw new BusinessException(ERR_COMPONENT + "101");
    } finally {
      try {
        if (out != null) out.close();
      } catch (IOException e) {
        e.printStackTrace();
      }
    }
  }