# 組件源碼 /** * <b>方法描述：</b> 取Excel列數據 <br/> * <b>創建者：</b> admin <br/> * <b>創建時間：</b> 2018-05-08 17:12:10 <br/> * * @param workBook * 入參|Excel對象|{@link Object} * @param sheet * 入參|工作簿索引或名稱|{@link java.lang.String} * @param col * 入參|列索引|{@link int} * @param coldata * 出參|列數據|{@link java.util.List} * @return -1 異常<br/> * 0 失敗<br/> * 1 成功<br/> */ @Component(label = "取Excel列數據", style = "判斷型", type = "同步組件", comment = "獲取Excel指定列數據", version = "1.0.0", deprecated = false, author = "admin", date = "2018-05-08 05:12:10") @InParams(param = { @Param(name = "workBook", comment = "Excel對象", type = Object.class), @Param(name = "sheet", comment = "工作簿索引或名稱", type = java.lang.String.class), @Param(name = "col", comment = "列索引", type = int.class) }) @OutParams(param = { @Param(name = "coldata", comment = "列數據", type = java.util.List.class) }) @Returns(returns = { @Return(id = "-1", desp = "異常"), @Return(id = "0", desp = "失敗"), @Return(id = "1", desp = "成功") }) public static ResultBase P_xlsGetColData(Object workBook, String sheet, int col) { if (!(workBook instanceof Workbook)) { ResultBase.newFailureResult("TPTF0005", "輸入Excel對象不正確,不是Workbook 對象"); } Workbook xlsObj = (Workbook) workBook; int nSheet = -1; try { nSheet = Integer.parseInt(sheet); } catch (Exception ex) { // AppLog.error(ex); AppLog.info("組件 輸入參數sheet 不是數字，按照名稱進行獲取"); // return ResultBase.newExceptionResult("TPTF0006", "sheet 參數不是 數字:" // + sheet); } Sheet sheetObj = ((nSheet > -1) ? xlsObj.getSheetAt(nSheet) : xlsObj .getSheet(sheet)); if (sheetObj == null) { return ResultBase.newFailureResult("TPTF0007", "找不到指定的工作簿,sheet=" + sheet); } int rownum = sheetObj.getPhysicalNumberOfRows(); // jxl.Cell[] cells = sheetObj.getColumn(col); java.util.List<Object> listRet = new java.util.LinkedList<Object>(); for (int i = 0; i < rownum; i++) { Row row = sheetObj.getRow(i); if (row.getPhysicalNumberOfCells() > col) { listRet.add(getCellFormatValue(row.getCell(col))); } else { listRet.add(""); } } return ResultBase.newSuccessResult(listRet); } 交易中組件使用方式：  ## 參數說明及示例 Excel對象：Excel對象，可以由其他技術組件傳遞，示例： `__INNER__["wb"]` 工作簿索引或名稱：sheet名稱或者索引，示例： `"sheet1"` 列索引：指定，示例： `3` 列數據：返回指定列對象的數據集合，示例： `__INNER__["cell"]` > 獲取Excel指定列數據