Java XLS 转 XLSX

最新推荐文章于 2024-07-22 02:04:39 发布

全子兄

最新推荐文章于 2024-07-22 02:04:39 发布

阅读量1.6k

点赞数

文章标签： java 服务器前端

本文链接：https://blog.csdn.net/m0_49790240/article/details/126413136

版权

 /**
     * XLS 转 XLSX
     *
     * @param file
     * @return
     */
    @AutoLog(value = "XLS 转 XLSX")
    @ApiOperation(value = "XLS 转 XLSX", notes = "XLS 转 XLSX")
    @GetMapping(value = "/xlsToXlsx")
    public void xlsToXlsx(HttpServletResponse response, String file, int sheetIndex) {
        try {
            File localFile = new File(BASE_PATH + File.separator + file);
            if (localFile.exists()) {
                response.setContentType("application/force-download");
                response.addHeader("Cache-Control", "no-cache, no-store, must-revalidate");
                response.addHeader("charset", "utf-8");
                response.addHeader("Pragma", "no-cache");
                response.addHeader("Content-Disposition", "attachment; filename=xlsx.xlsx");

                com.spire.xls.Workbook book = new com.spire.xls.Workbook();
                book.loadFromStream(new FileInputStream(localFile));
                Worksheet sheet = book.getWorksheets().get(sheetIndex);
                OutputStream stream = response.getOutputStream();
                sheet.getBook().saveToStream(stream, FileFormat.Version2016);
                stream.flush();
                stream.close();
                sheet.dispose();
                book.dispose();
            }
        } catch (Exception e) {
            log.error(e.getMessage());
        }
    }