JXLS模板导出excel--项目版

最新推荐文章于 2024-06-27 10:02:43 发布

夕颜以北

最新推荐文章于 2024-06-27 10:02:43 发布

阅读量488

点赞数

CC 4.0 BY-SA版权

分类专栏： java 文章标签： JXLS java

本文链接：https://blog.youkuaiyun.com/github_39698303/article/details/76591457

java 专栏收录该内容

23 篇文章

订阅专栏

本文介绍如何使用JXLS库实现Excel文件的导出功能。通过具体代码示例展示了从Maven依赖配置到控制器类的具体实现过程，并提供了一个实际使用的模板文件路径。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

JXLS模板导出EXLS

项目用到，记录下。

1、maven依赖

<dependency>  
    <groupId>net.sf.jxls</groupId>  
    <artifactId>jxls-core</artifactId>  
    <version>1.0.5</version>  
</dependency>

2、ExportController.java

package com.rivers.shopkeeper.controller.export;

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.URL;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Map;
import java.util.Objects;

import javax.servlet.http.HttpServletResponse;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;

import com.google.common.collect.Maps;
import com.rivers.shopkeeper.dto.export.ExportOrderDTO;
import com.rivers.shopkeeper.service.export.ExportService;

import net.sf.jxls.transformer.XLSTransformer;

/**
 * 导出
 * 
 * @author xiyan
 *
 */
@Controller
@Scope("prototype")
@RequestMapping(value = "/s/export")
public class ExportController {

    @Autowired
    private ExportService service;

    /**
     * 导出订单
     */
    @GetMapping(value = "/exportExcelOrder")
    public void exportExcelOrder(HttpServletResponse response, String orderCode, String mobile) {
        ExportOrderDTO dto = service.findExportOrderDTOByOrderCode(orderCode, mobile);
        if (Objects.nonNull(dto)) {
            Map<String, ExportOrderDTO> beans = Maps.newHashMap();
            beans.put("entity", dto);
            XLSTransformer transformer = new XLSTransformer();
            InputStream in = null;
            OutputStream out = null;
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd-HHmmss");
            String outputFileName = "OrderDetail_" + sdf.format(new Date()) + ".xlsx";
            response.setHeader("Content-Disposition", "attachment;filename=" + outputFileName);
            response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=UTF-8");
            try {
                URL url = this.getClass().getResource("order_template.xlsx");
                File file = new File(url.getFile());
                in = new BufferedInputStream(new FileInputStream(file));
                Workbook workbook = transformer.transformXLS(in, beans);
                out = response.getOutputStream();
                workbook.write(out);
                out.flush();
            } catch (InvalidFormatException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            } finally {
                if (in != null) {
                    try {
                        in.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
                if (out != null) {
                    try {
                        out.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }
}