Excel导入导出Controller

该博客展示了如何使用Hutool库在Java中处理Excel文件,包括读取Excel数据并导出到新的Excel文件。主要涉及的功能有:从InputStream读取Excel,转换为List数据结构,以及将数据写回Excel并以特定格式下载。

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

import cn.hutool.core.date.DateUtil;
import cn.hutool.core.io.IoUtil;
import cn.hutool.poi.excel.ExcelReader;
import cn.hutool.poi.excel.ExcelUtil;
import cn.hutool.poi.excel.ExcelWriter;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.net.URLEncoder;
import java.util.List;

/**
 * @author 
 * @version 1.0
 * @description:
 * @date 
 */
@RestController
@RequestMapping("excel")
public class ExcelController {

    @GetMapping()
    public void excel(HttpServletResponse response) throws FileNotFoundException {

        FileInputStream fis = new FileInputStream("D:\\test.xlsx");
        try {
            List<List<Object>> lists = importExcel(null, fis);
            exportExcel(lists, response);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


    public static List<List<Object>> importExcel(MultipartFile file, InputStream in) throws IOException {
        ExcelReader excelReader = ExcelUtil.getReader(in);
        return excelReader.read();
    }

    public static void exportExcel(List<List<Object>> list, HttpServletResponse response) throws IOException {
        ExcelWriter writer = ExcelUtil.getWriter();
        List<Object> rowHead = list.get(0);
        //rowHead.add(4, "herd");
        writer.writeHeadRow(rowHead);
        writer.write(list);
        response.setContentType("application/vnd.ms-excel;charset=utf-8");
        response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode("test-" + DateUtil.today() + ".xls", "utf-8"));
        ServletOutputStream out = response.getOutputStream();
        writer.flush(out, true);
        writer.close();
        IoUtil.close(out);
    }


    public static String rule(String cvsString) {
        String one = cvsString.substring(0, 10);
        String two = cvsString.substring(13, 16);
        String three = cvsString.substring(16);
        int i1 = Integer.parseInt(three);
        if (i1 > 99) {
            return "数据异常";
        }
        int i;
        if (i1 > 9) {
            i = i1;
        } else {
            i = i1 * 10;
        }
        return one + "132" + two + i + "**";
    }
}
<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>5.6.6</version>
</dependency>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值