Loading...
Loading...
Found 2 Skills
基于 Alibaba EasyExcel（com.alibaba:easyexcel:4.0.3）的 Excel 数据读取技能。覆盖监听器模式（ReadListener/AnalysisEventListener/PageReadListener）、同步读取（doReadSync）、多 Sheet 读取、@ExcelProperty(index/name)匹配、多行表头（headRowNumber）、日期数字自定义转换器（@DateTimeFormat/@NumberFormat/Converter）、监听器异常处理（onException + ExcelDataConvertException）、额外信息读取（批注/超链接/合并单元格，extraRead + CellExtra）、公式和单元格类型（CellData<T>）、不创建对象的读（ReadListener<Map<Integer,String>>）、Web 上传读取（MultipartFile→InputStream）。当用户需要解析 Excel（导入数据/批量入库/对账文件/用户上传/Excel 转对象/Excel 转 Map）时使用此技能，不适用于按预制模板填充（改用 easyexcel-fill）、不适用于程序化生成 Excel（改用 easyexcel-write）。
An Excel data-writing skill based on Alibaba EasyExcel (com.alibaba:easyexcel:4.0.3). It covers the simplest write methods (3 approaches), complex headers (multi-level), the @ExcelProperty/@ExcelIgnore/@DateTimeFormat/@NumberFormat annotations, selective column export with includeColumn/excludeColumn, style annotations such as @ColumnWidth/@ContentRowHeight, custom styles with @HeadStyle/@ContentStyle, merged cells (@ContentLoopMerge/LoopMergeStrategy), image export (File/InputStream/URL/byte[]), hyperlinks/comments/formulas/rich text (WriteCellData), dynamic headers, automatic column widths, custom interceptors (CellWriteHandler/SheetWriteHandler/RowWriteHandler), paginated and batched writing, direct web downloads to OutputStream, and 03/07 version compatibility. Use this skill when users need to programmatically generate Excel files without predefined templates to export structured data such as orders, users, financial records, inventory, reports, statements, or approval forms. It is not suitable for populating predefined templates; use easyexcel-fill instead. It is also not suitable for reading Excel files; use easyexcel-read instead.