| | |
| | | import cn.idev.excel.exception.ExcelCommonException; |
| | | import cn.idev.excel.exception.ExcelDataConvertException; |
| | | import cn.iocoder.yudao.framework.common.util.http.HttpUtils; |
| | | import cn.iocoder.yudao.framework.excel.core.convert.ListJsonStringConverter; |
| | | import cn.iocoder.yudao.framework.excel.core.convert.LocalTimeStringConverter; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import cn.iocoder.yudao.framework.excel.core.handler.ColumnWidthMatchStyleStrategy; |
| | | import cn.iocoder.yudao.framework.excel.core.handler.DateAsTextCellWriteHandler; |
| | |
| | | .registerWriteHandler(new ColumnWidthMatchStyleStrategy()) // 基于 column 长度,自动适配。最大 255 宽度 |
| | | .registerWriteHandler(new SelectSheetWriteHandler(head)) // 基于固定 sheet 实现下拉框 |
| | | .registerConverter(new LongStringConverter()) // 避免 Long 类型丢失精度 |
| | | .registerConverter(new LocalTimeStringConverter()) // FastExcel 内置无 LocalTime,缺少时会抛 Can not find 'Converter' |
| | | .registerConverter(new ListJsonStringConverter()) // FastExcel 内置无 List,缺少时会抛 Can not find 'Converter' |
| | | .build(); |
| | | try { |
| | | excelWriter.write(data, FastExcelFactory.writerSheet(sheetName).build()); |
| | |
| | | .registerWriteHandler(new SelectSheetWriteHandler(head)) |
| | | .registerWriteHandler(new DateAsTextCellWriteHandler()) |
| | | .registerConverter(new LongStringConverter()) |
| | | .registerConverter(new LocalTimeStringConverter()) |
| | | .registerConverter(new ListJsonStringConverter()) |
| | | .build(); |
| | | try { |
| | | excelWriter.write(data, FastExcelFactory.writerSheet(sheetName).build()); |