springboot从java下载excel模板

最新推荐文章于 2024-04-23 15:02:57 发布

H丶Jack

最新推荐文章于 2024-04-23 15:02:57 发布

阅读量293

点赞数

分类专栏：项目文章标签： Apache POI Spring Boot Excel模板下载 Maven依赖

本文链接：https://blog.csdn.net/j_s_king/article/details/113975555

版权

项目专栏收录该内容

16 篇文章 0 订阅

订阅专栏

    <!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
	<dependency>
	    <groupId>org.apache.poi</groupId>
	    <artifactId>poi</artifactId>
	    <version>3.17</version>
	</dependency>
	<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
	<dependency>
	    <groupId>org.apache.poi</groupId>
	    <artifactId>poi-ooxml</artifactId>
	    <version>3.17</version>
	</dependency>

	<build>
		<resources>
	        <resource>
	            <directory>src/main/resources</directory>
	            <includes>
	                <include>static/templates/*.xlsx</include>
	            </includes>
	            <!--是否替换资源中的属性-->
	            <filtering>false</filtering>
	        </resource>
	    </resources> 
	</build>

import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.net.URLEncoder;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.core.io.ClassPathResource;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import cn.hutool.core.io.resource.Resource;

@RestController
@RequestMapping("excel")
public class ExcelDownloadController {
	
	@RequestMapping(value="/downloadExcel")
    public ResponseEntity<Resource> downloadExcel(HttpServletResponse response, HttpServletRequest request) {
        try {
            ClassPathResource cpr = new ClassPathResource("/static/templates/test.xlsx");
            InputStream is = cpr.getInputStream();
            Workbook workbook = new XSSFWorkbook(is);
            String fileName = "test.xlsx";
            downLoadExcel(fileName, response, workbook);
 
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return new ResponseEntity<Resource>(HttpStatus.OK);
    }
	
	public static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {
        try {
            response.setCharacterEncoding("UTF-8");
            response.setHeader("content-Type", "application/vnd.ms-excel");
            response.setHeader("Content-Disposition",
                    "attachment;filename=\"" + URLEncoder.encode(fileName, "UTF-8") + "\"");
            workbook.write(response.getOutputStream());
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}