# 組件源碼 /** * <b>方法描述：</b> 打開Excel文件 <br/> * <b>創建者：</b> admin <br/> * <b>創建時間：</b> 2018-05-08 17:11:28 <br/> * * @param fileName * 入參|文件名|{@link java.lang.String} * @param workBook * 出參|工作簿|{@link Object} * @return -1 異常<br/> * 1 成功<br/> */ @Component(label = "打開Excel文件", style = "判斷型", type = "同步組件", comment = "打開EXCEL文件，返回workbook對象,需要注意，如果是大文件存在性能問題。應采用流式讀取", version = "1.0.0", deprecated = false, author = "admin", date = "2018-05-08 05:11:28") @InParams(param = { @Param(name = "fileName", comment = "文件名", type = java.lang.String.class) }) @OutParams(param = { @Param(name = "workBook", comment = "工作簿", type = Object.class) }) @Returns(returns = { @Return(id = "-1", desp = "異常"), @Return(id = "1", desp = "成功") }) public static ResultBase P_xlsOpen(String fileName) { File xlsFile = new File(fileName); try { InputStream is = new FileInputStream(fileName); if (fileName.toLowerCase().endsWith(".xls")) { return ResultBase.newSuccessResult(new HSSFWorkbook(is)); } else { return ResultBase.newSuccessResult(new XSSFWorkbook(is)); } } catch (Exception ex) { AppLog.error(ex); return ResultBase.newExceptionResult("TPTF0004", "打開Excel文件" + fileName + "異常" + AppLog.errorMsg(ex)); } } 交易中組件使用方式：  ## 參數說明及示例 文件名：文件全路徑，示例： `"/home/usr/local/test.xls"` 工作簿：工作簿對象，示例： `__INNER__["wb"]` > 打開EXCEL文件，返回workbook對象,需要注意，如果是大文件存在性能問題。應采用流式讀取