spring整合导出excle和PDF

最新推荐文章于 2021-01-17 18:21:50 发布

qq_42996037

最新推荐文章于 2021-01-17 18:21:50 发布

阅读量161

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/qq_42996037/article/details/96703667

版权

java 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

导出excle表格

添加依赖
使用apache的开源框架POI

<dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>3.16</version>
</dependency>

编写自定义的excel视图

import com.chenx.domain.District;
import org.apache.commons.beanutils.BeanUtils;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import org.springframework.web.servlet.view.document.AbstractXlsView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;

/**
 * Created by ChenX on 2017/8/13.
 */
//想要导出excel,需要继承AbstractXlsView(office2007之前的版本依然可以识别)
// ，AbstractXlsxView(office2007版之后的版本才能打开)，为了满足大部分人，选择第一种继承
public class DistrictExcelView extends AbstractXlsView {
    //重写方法
    @Override
    protected void buildExcelDocument(Map<String, Object> model,
                                      Workbook workbook,
                                      HttpServletRequest request,
                                      HttpServletResponse response) throws Exception {
        //url中传中文必须转成%编码才能识别
        String filename = URLEncoder.encode("省市表格.xls","utf-8");
        response.setHeader("Content-Disposition","attachment; filename="+filename);
        HSSFWorkbook book = (HSSFWorkbook) workbook;//对应一个excel文件
        HSSFSheet sheet = book.createSheet("省市区汇总");//在webbook中添加一个sheet,对应Excel文件中的sheet
        HSSFRow row = sheet.createRow(0);//设置表头第0行
        String[] colNames = {"省名字","市名字","地区名字"};
        for (int i = 0; i < colNames.length ; i++) {
            HSSFCell cell = row.createCell(i);
            cell.setCellValue(colNames[i]);
        }
        List<District> districts = (List<District>) model.get("districts");
        int rowIndex = 1;//第0行是表头，所以设置从第一行开始
        String[] propNames = { "city.province.name", "city.name", "name" };
        for (District district : districts
                ) {
            HSSFRow sheetRow = sheet.createRow(rowIndex);
            for (int i = 0; i < propNames.length; i++) {
                HSSFCell cell = sheetRow.createCell(i);
                //使用反射取值
                cell.setCellValue(BeanUtils.getProperty(district,propNames[i]));
            }
            rowIndex++;
        }
    }
}

编写控制器

@GetMapping("/exp")
    public String exportDistricts(ModelMap map) {
        List<District> districts = distService.listAllDistricts();
        map.put("districts", districts);
        return "distExcel";
    }

PDF文档

添加依赖
itext的版本最新已经是5.x了，但是要在spring中使用itex只能支持使用2.x的版本

<dependency>
     <groupId>com.lowagie</groupId>
     <artifactId>itext</artifactId>
     <version>2.1.7</version>
</dependency>

编写自定义的PDF视图

import com.chenx.domain.District;
import com.chenx.utils.PDFUtil;
import com.lowagie.text.*;
import com.lowagie.text.pdf.PdfPTable;

import com.lowagie.text.pdf.PdfWriter;
import org.apache.commons.beanutils.BeanUtils;
import org.springframework.web.servlet.view.document.AbstractPdfView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;

/**
 * Created by ChenX on 2017/8/13.
 */
public class DistrictPdfView extends AbstractPdfView {
    private final String title_content = "省市区详情";
    private final String[] table_head = {"省名字","市名字","区名字"};
    @Override
    protected void buildPdfDocument(Map<String, Object> model,
                                    Document document,
                                    PdfWriter writer,
                                    HttpServletRequest request,
                                    HttpServletResponse response) throws Exception {
        String filename = URLEncoder.encode("省市区详情.pdf","utf-8");
        response.setHeader("Content-Disposition", "inline; filename=" + filename);
        document.open();
        //标题
        Paragraph title = PDFUtil.getParagraph(
                new Chunk(title_content,new Font(PDFUtil.bfChinese,16,Font.BOLD)));
        title.setAlignment(Paragraph.ALIGN_CENTER);
        document.add(title);
        //表格标题
        PdfPTable table = new PdfPTable(table_head.length);
        table.setSpacingBefore(20);
        table.setSpacingAfter(30);
        for (String str: table_head
             ) {
            table.addCell(PDFUtil.getParagraph(str));
        }
        String[] propNames = {"city.province.name", "city.name", "name"};
        //表格内容
        List<District> distList = (List<District>) model.get("districts");
        if (null!=distList){
            for (District district:distList
                    ) {
                for (int i = 0; i < propNames.length; i++) {
                    String content = BeanUtils.getProperty(district, propNames[i]);
                    table.addCell(PDFUtil.getParagraph(content));
                }
            }
        }
        document.add(table);
        document.close();
    }
}

因为itex默认是不支持中文字体的，所以必须给它添加中文字体，用了一个PDFUtil工具类封装了字体，样式等功能

PDFUtil工具类

import com.lowagie.text.Chunk;
import com.lowagie.text.DocumentException;
import com.lowagie.text.Font;
import com.lowagie.text.Paragraph;
import com.lowagie.text.pdf.BaseFont;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

public class PDFUtil {
    // 对参数的封装形式比如{name}
    public static final String BEGIN = "{";
    public static final String END = "}";
    // 换行形式{#}
    public static final String NEW_LINE = "#";
    // 默认的行间距、首行距离等，自己添加
    public static final float DEFAULT_LEADING = 20;
    public static final float DEFAULT_LINE_INDENT = 30;


    // 基本字体和样式
    public static BaseFont bfChinese;
    public static Font fontChinese;
    public static Font UNDER_LINE = null;
    static{
        try {
            // SIMKAI.TTF 默认系统语言，这里没使用第三方语言包
            //bfChinese = BaseFont.createFont(PDFTest.class.getResource("/content/")+"SIMKAI.TTF",BaseFont.IDENTITY_H,BaseFont.NOT_EMBEDDED);
            bfChinese = BaseFont.createFont("c:/Windows/Fonts/STXINWEI.TTF",BaseFont.IDENTITY_H,true);

            fontChinese = new Font(bfChinese, 14, Font.NORMAL);
            UNDER_LINE = new Font(bfChinese, 14,Font.UNDERLINE);
        } catch (DocumentException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    // 默认样式
    public static Paragraph getParagraph(String context){
        return getParagraph(context,fontChinese);
    }

    public static Paragraph getParagraph(Chunk chunk){
        return new Paragraph(chunk);
    }

    // 指定字体样式
    public static Paragraph getParagraph(String context,Font font){
        return new Paragraph(context,font);
    }

    // 获得新行,首行缩进,和行间距
    public static Paragraph getNewParagraph(String context,float fixedLeading,float firstLineIndent){
        Paragraph p = getParagraph(context);
        p.setLeading(fixedLeading);
        p.setFirstLineIndent(firstLineIndent);
        return p;
    }

    public static Paragraph getParagraph(String content , Font font , float fixedLeading , int alignment){
        Paragraph p = getParagraph(content);
        p.setFont(font);
        p.setLeading(fixedLeading);
        p.setAlignment(alignment);
        return p;
    }

    // 默认段落样式
    public static Paragraph getDefaultParagraph(String context){
        Paragraph p = getParagraph(context);
        // 默认行间距
        p.setLeading(DEFAULT_LEADING);
        // 默认首行空隙
        p.setFirstLineIndent(DEFAULT_LINE_INDENT);
        return p;
    }

    // 将参数和字符串内容组合成集合
    public static List<Paragraph> createParagraphs(String context , Map<String,Object> map){
        int index = 0;
        List<Paragraph> list = new ArrayList<Paragraph>();
        Paragraph p = getDefaultParagraph(null);
        while((index  = context.indexOf(BEGIN)) > -1){
            String text = context.substring(0,index);
            context = context.substring(index, context.length());
            index = context.indexOf(END);
            String param =  null;
            if(index > 0){
                param = context.substring(BEGIN.length(),index);
            }
            p.add(text);
            if(!NEW_LINE.equals(param)){
                Object value = map.get(param);
                if(value != null){
                    p.add(new Chunk(value.toString(),UNDER_LINE));
                }else{
                    p.add(new Chunk(""));
                }
            }else{
                list.add(p);
                p = getDefaultParagraph(null);
                p.setSpacingBefore(0);
            }
            context = context.substring(index+END.length(),context.length());
        }
        list.add(p);
        list.add(getParagraph(context));
        return list;
    }
}

编写控制器

@GetMapping("/pdf")
    public String exportDistrictsToPdf(ModelMap map) {
        List<District> districts = distService.listAllDistricts();
        map.put("districts", districts);
        return "distPdf";
    }

在PDF中输出图片
在刚刚的自定义视图中添加如下代码

document.newPage();
        //添加图片
        String path = request.getServletContext().getRealPath("/images") + "/" + "mm.jpg";
        try (InputStream in = new FileInputStream(path)) {
            byte[] buffer = new byte[in.available()];
            in.read(buffer);
            // URL url = new URL("https://www.baidu.com/img/bd_logo1.png");
            Image image = Image.getInstance(buffer);
            image.scaleToFit(PageSize.A4.getWidth(), PageSize.A4.getHeight());
            document.add(image);
        }

qq_42996037

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
spring整合导出excle和PDF

导出excle表格添加依赖使用apache的开源框架POI <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.16</version><...
复制链接

扫一扫