| | |
|---|
| | | import cn.hutool.core.util.IdUtil; |
|---|
| | | import com.alibaba.excel.EasyExcel; |
|---|
| | | import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy; |
|---|
| | | import com.ruoyi.common.convert.ExcelBigNumberConvert; |
|---|
| | | import com.ruoyi.common.utils.DictUtils; |
|---|
| | | import com.ruoyi.common.utils.StringUtils; |
|---|
| | | import com.ruoyi.common.utils.file.FileUtils; |
|---|
| | |
|---|
| | | * @return 转换后集合 |
|---|
| | | */ |
|---|
| | | public static <T> List<T> importExcel(InputStream is, Class<T> clazz) { |
|---|
| | | return EasyExcel.read(is).autoCloseStream(false).sheet().doReadSync(); |
|---|
| | | return EasyExcel.read(is).head(clazz).autoCloseStream(false).sheet().doReadSync(); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | response.reset(); |
|---|
| | | response.addHeader("Access-Control-Allow-Origin", "*"); |
|---|
| | | response.addHeader("Access-Control-Expose-Headers", "Content-Disposition"); |
|---|
| | | FileUtils.setAttachmentResponseHeader(response, URLEncoder.encode(filename, StandardCharsets.UTF_8.toString())); |
|---|
| | | FileUtils.setAttachmentResponseHeader(response, filename); |
|---|
| | | response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8"); |
|---|
| | | ServletOutputStream os = response.getOutputStream(); |
|---|
| | | EasyExcel.write(os, clazz) |
|---|
| | | .autoCloseStream(false) |
|---|
| | | // 自动适配 |
|---|
| | | .registerWriteHandler(new LongestMatchColumnWidthStyleStrategy()) |
|---|
| | | // 大数值自动转换 防止失真 |
|---|
| | | .registerConverter(new ExcelBigNumberConvert()) |
|---|
| | | .sheet(sheetName).doWrite(list); |
|---|
| | | } catch (IOException e) { |
|---|
| | | throw new RuntimeException("导出Excel异常"); |
|---|
