# 組件源碼 /** * <b>方法描述：</b> sheet列表 <br/> * <b>創建者：</b> admin <br/> * <b>創建時間：</b> 2019-05-28 16:20:05 <br/> * * @param wb * 入參|工作簿| {@link org.apache.poi.ss.usermodel.Workbook} * @param sheets * 出參|列表| {@link java.util.List} * @return 0 失敗<br/> * 1 成功<br/> */ @Component(label = "sheet列表", style = "判斷型", type = "同步組件", version = "1.0.0", deprecated = false, author = "admin", date = "2019-05-28 04:20:05") @InParams(param = { @Param(name = "wb", comment = "工作簿", type = org.apache.poi.ss.usermodel.Workbook.class) }) @OutParams(param = { @Param(name = "sheets", comment = "列表", type = java.util.List.class) }) @Returns(returns = { @Return(id = "0", desp = "失敗"), @Return(id = "1", desp = "成功") }) public static ResultBase A_getSheets(Workbook wb) { int totalSheet = wb.getNumberOfSheets(); List<Sheet> result = new ArrayList<>(totalSheet); for (int i = 0; i < totalSheet; i++) { result.add(wb.getSheetAt(i)); } return ResultBase.newSuccessResult(result); } 交易中組件使用方式：  ## 參數說明及示例 工作簿：需要獲取sheet集合的工作簿，可以是其他技術組件傳遞過來的工作簿，示例： `__INNER__["wb"]` 列表：當前工作簿的sheet集合，示例： `__INNER__["count"]` > 獲取當前工作簿的sheet列表