企业🤖AI智能体构建引擎,智能编排和调试,一键部署,支持私有化部署方案 广告
# 组件源码 /** * <b>方法描述:</b> 获取sheet <br/> * <b>创建者:</b> admin <br/> * <b>创建时间:</b> 2019-05-28 16:52:09 <br/> * * @param index * 入参|坐标| {@link int} * @param wb * 入参|工作簿| {@link org.apache.poi.ss.usermodel.Workbook} * @param sheet * 出参|页| {@link org.apache.poi.sl.usermodel.Sheet} * @return 0 失败<br/> * 1 成功<br/> */ @Component(label = "获取sheet", style = "判断型", type = "同步组件", version = "1.0.0", deprecated = false, author = "admin", date = "2019-05-28 04:52:09") @InParams(param = { @Param(name = "index", comment = "坐标", type = int.class), @Param(name = "wb", comment = "工作簿", type = org.apache.poi.ss.usermodel.Workbook.class) }) @OutParams(param = { @Param(name = "sheet", comment = "页", type = org.apache.poi.ss.usermodel.Sheet.class) }) @Returns(returns = { @Return(id = "0", desp = "失败"), @Return(id = "1", desp = "成功") }) public static ResultBase A_getSheet(int index, Workbook wb) { return ResultBase.newSuccessResult(wb.getSheetAt(index)); } 交易中组件使用方式: ![](https://img.kancloud.cn/f6/76/f676756e0ea3f0149146c0f6fe950d18_950x750.jpg) ## 参数说明及示例 坐标:需要获取sheet集合的工作簿,可以是其他技术组件传递过来的工作簿,示例: `1` 工作簿:当前工作簿的sheet集合,示例: `__INNER__["wb"]` 页:当前工作簿的sheet集合,示例: `__INNER__["sheet"]` > 获取当前工作簿指定坐标的sheet页