浏览器下载文档模板，为数据批量导入做准备

最新推荐文章于 2024-07-19 18:49:54 发布

识时务者111

最新推荐文章于 2024-07-19 18:49:54 发布

阅读量341

点赞数 10

分类专栏：实用工具快速开发文章标签： spring boot java

本文链接：https://blog.csdn.net/fcfs_sstf/article/details/136297469

版权

实用工具快速开发专栏收录该内容

5 篇文章 0 订阅

订阅专栏

下载模板

在resource下新增tst.xlsx模板文档

开发代码：

package cn.@@.forecast.controller;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.xmlbeans.ResourceLoader;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.net.URL;
import java.net.URLEncoder;

@RequestMapping("/downLoad")
@RestController
@Slf4j
@Api(tags = "模板下载")
public class testDownLoad {
    @ApiOperation(value = "导出模板", httpMethod = "POST")
    @GetMapping("/muban")
    public void downLoadExcel(HttpServletResponse response, HttpServletRequest request) {
        // 清空response
        try {
            String fileName = "上传模板.xlsx";

            String userAgent = request.getHeader("User-Agent");
            if (userAgent != null && (userAgent.contains("MSIE") || userAgent.contains("Trident"))) {
                fileName = URLEncoder.encode(fileName, "UTF-8");
            } else {
                // 非IE浏览器的处理：
                fileName = new String(fileName.getBytes("UTF-8"), "ISO-8859-1");
            }

            // 设置response的Header
            int totalBytesRead = 0;
            response.addHeader("Content-Disposition", "attachment;filename=" + fileName);
//            response.setHeader("Content-Length", String.valueOf(totalBytesRead));
            response.setContentType("application/octet-stream");
            try (InputStream in = Thread.currentThread().getContextClassLoader().getResourceAsStream("tst.xlsx");
                 OutputStream toClient = new BufferedOutputStream(response.getOutputStream())) {
                byte[] buffer = new byte[1024];
                int bytesRead;
                while ((bytesRead = in.read(buffer)) != -1) {
                    toClient.write(buffer, 0, bytesRead);
                    totalBytesRead += bytesRead;
                }
                toClient.flush();
            }
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}