springboot 文件下载

Java导出Excel与PDF文件

最新推荐文章于 2024-10-30 15:09:34 发布

原创最新推荐文章于 2024-10-30 15:09:34 发布 · 162 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#文件下载 #excel #springboot

springboot 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一个使用Java实现的简单示例，该示例能够导出包含表头的Excel文件，并支持从本地下载指定的PDF文件。通过具体代码展示了如何创建Excel工作簿、设置样式、填充数据并进行响应式内容类型配置。

package com.example.file.controller;

import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;


@RestController
public class ExportController {

    /**
     * 导出excel
     * @param response
     */
    @GetMapping("/exportExcel")
    public void fileDownLoad(HttpServletResponse response) {
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook();
        HSSFSheet sheet = hssfWorkbook.createSheet("sheet");
        // 一个创建excel标题的的方法
        createTitle(hssfWorkbook, sheet);
        try {
            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
            response.setCharacterEncoding("UTF-8");
            response.setHeader("Content-Disposition", "attachment;filename=" +
                    java.net.URLEncoder.encode("测试.xls", "UTF-8"));
            OutputStream outputStream = response.getOutputStream();
            hssfWorkbook.write(outputStream);
            outputStream.flush();
            outputStream.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 创建表头
     *
     * @param workbook
     * @param sheet
     */
    private void createTitle(HSSFWorkbook workbook, HSSFSheet sheet) {
        HSSFRow row = sheet.createRow(0);
        //设置为居中加粗
        HSSFCellStyle style = workbook.createCellStyle();
        style.setAlignment(HorizontalAlignment.CENTER);
        HSSFFont font = workbook.createFont();
        style.setFont(font);

        HSSFCell cell;
        cell = row.createCell(0);
        cell.setCellValue("测试1");
        cell.setCellStyle(style);


        cell = row.createCell(1);
        cell.setCellValue("测试2");
        cell.setCellStyle(style);

        cell = row.createCell(2);
        cell.setCellValue("测试3");
        cell.setCellStyle(style);

    }

    /**
     * 下载文件
     * @param response
     * @return
     */
    @GetMapping(value = "/exportFile")
    public void expertExcel(HttpServletResponse response) {
        File file = new File("/Volumes/Personal/remark.pdf");
        try {
            InputStream fis = new BufferedInputStream(new FileInputStream(file));
            byte[] buffer = new byte[fis.available()];
            fis.read(buffer);
            response.addHeader("Content-Length", "" + file.length());
            OutputStream toClient = new BufferedOutputStream(response.getOutputStream());
            response.setContentType("application/octet-stream;charset=utf-8");
            toClient.write(buffer);
            toClient.flush();
            fis.close();
            toClient.close();
        } catch (IOException ex) {
            ex.printStackTrace();
        }
    }
}