利用若依@Excel注解导出PDF工具类

利用若依@Excel注解导出PDF工具类

1.pom依赖

        <!--PDF导出-->
        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itextpdf</artifactId>
            <version>5.5.13.2</version>
        </dependency>
        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itext-asian</artifactId>
            <version>5.2.0</version>
        </dependency>
        <!-- pdf 加权限 添加以下包不然会报错-->
        <dependency>
            <groupId>org.bouncycastle</groupId>
            <artifactId>bcprov-jdk15on</artifactId>
            <version>1.47</version>
        </dependency>
        <dependency>
            <groupId>org.bouncycastle</groupId>
            <artifactId>bcmail-jdk15on</artifactId>
            <version>1.47</version>
        </dependency>

2.PDFBuilder

import com.itextpdf.text.*;
import com.itextpdf.text.pdf.*;
import java.io.IOException;

public class PDFBuilder extends PdfPageEventHelper {
    /**
     * 页眉
     */
    public String header = "";

    /**
     * 文档字体大小,页脚页眉最好和文本大小一致
     */
    public int presentFontSize = 12;


    // 模板
    public PdfTemplate total;

    // 基础字体对象
    public BaseFont bf = null;

    // 利用基础字体生成的字体对象,一般用于生成中文文字
    public Font fontDetail = null;

    /**
     *
     * Creates a new instance of PdfReportM1HeaderFooter 无参构造方法.
     *
     */
    public PDFBuilder() {

    }

    public void setHeader(String header) {
        this.header = header;
    }

    /**
     *
     * TODO 文档打开时创建模板
     *
     * @see com.itextpdf.text.pdf.PdfPageEventHelper#onOpenDocument(com.itextpdf.text.pdf.PdfWriter,
     *      com.itextpdf.text.Document)
     */
    public void onOpenDocument(PdfWriter writer, Document document) {
        total = writer.getDirectContent().createTemplate(50, 50);// 共 页 的矩形的长宽高
    }

    /**
     *
     * TODO 关闭每页的时候,写入页眉,写入'第几页共'这几个字。
     *
     * @see com.itextpdf.text.pdf.PdfPageEventHelper#onEndPage(com.itextpdf.text.pdf.PdfWriter,
     *      com.itextpdf.text.Document)
     */
    public void onEndPage(PdfWriter writer, Document document) {
        this.addPage(writer, document);
    }

    //加分页
    public void addPage(PdfWriter writer, Document document){
        try {
            if (bf == null) {
                bf = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H", false);
            }
            if (fontDetail == null) {
                fontDetail = new Font(bf, presentFontSize, Font.NORMAL);// 数据体字体
            }
        } catch (DocumentException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }

        // 1.写入页眉
        ColumnText.showTextAligned(writer.getDirectContent(),
                Element.ALIGN_LEFT, new Phrase(header, fontDetail),
                document.left(), document.top() + 20, 0);
        // 2.写入前半部分的 第 X页/共
        int pageS = writer.getPageNumber();
        String foot1 = "第 " + pageS + " 页 / 共";
        Phrase footer = new Phrase(foot1, fontDetail);

        // 3.计算前半部分的foot1的长度,后面好定位最后一部分的'Y页'这俩字的x轴坐标,字体长度也要计算进去 = len
        float len = bf.getWidthPoint(foot1, presentFontSize);

        // 4.拿到当前的PdfContentByte
        PdfContentByte cb = writer.getDirectContent();

        // 5.写入页脚1,x轴就是(右margin+左margin + right() -left()- len)/2.0F
        // 再给偏移20F适合人类视觉感受,否则肉眼看上去就太偏左了
        // ,y轴就是底边界-20,否则就贴边重叠到数据体里了就不是页脚了;注意Y轴是从下往上累加的,最上方的Top值是大于Bottom好几百开外的。
        ColumnText
                .showTextAligned(
                        cb,
                        Element.ALIGN_CENTER,
                        footer,
                        (document.rightMargin() + document.right()
                                + document.leftMargin() - document.left() - len) / 2.0F + 20F,
                        document.bottom() - 20, 0);

        // 6.写入页脚2的模板(就是页脚的Y页这俩字)添加到文档中,计算模板的和Y轴,X=(右边界-左边界 - 前半部分的len值)/2.0F +
        // len , y 轴和之前的保持一致,底边界-20
        cb.addTemplate(total, (document.rightMargin() + document.right()
                        + document.leftMargin() - document.left()) / 2.0F + 20F,
                document.bottom() - 20); // 调节模版显示的位置

    }


    /**
     *
     * TODO 关闭文档时,替换模板,完成整个页眉页脚组件
     *
     * @see com.itextpdf.text.pdf.PdfPageEventHelper#onCloseDocument(com.itextpdf.text.pdf.PdfWriter,
     *      com.itextpdf.text.Document)
     */
    public void onCloseDocument(PdfWriter writer, Document document) {
        // 7.最后一步,是关闭文档的时候,将模板替换成实际的 Y 值,至此,page x of y 制作完毕,完美兼容各种文档size。
        total.beginText();
        total.setFontAndSize(bf, presentFontSize);// 生成的模版的字体、颜色
        String foot2 = " " + (writer.getPageNumber()) + " 页";
        total.showText(foot2);// 模版显示的内容
        total.endText();
        total.closePath();
    }
}

3.PDFUtil

package com.bims.common.utils.poi;

import com.bims.common.annotation.Excel;
import com.bims.common.annotation.Excels;
import com.bims.common.config.Global;
import com.bims.common.core.domain.AjaxResult;
import com.bims.common.utils.DateUtils;
import com.itextpdf.text.*;
import com.itextpdf.text.pdf.*;

import java.io.*;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.List;

import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;


public class PDFUtil<T> {
    private static final Logger log = LoggerFactory.getLogger(PDFUtil.class);

    // ============================================样式设置
    // 开始=======================
    private static Font headfont; // 设置字体大小
    private static Font keyfont; // 设置字体大小
    private static Font textfont; // 设置字体大小

    /**
     * 实体对象
     */
    public Class<T> clazz;

    public PDFUtil(Class<T> clazz) {
        this.clazz = clazz;
    }

    /**
     * 文件表头
     */
    private String title;
    /**
     * 导入导出数据列表
     */
    private List<T> list;

    /**
     * 导出类型(EXPORT:导出数据;IMPORT:导入模板)
     */
    private Excel.Type type;

    /**
     * 注解列表
     */
    private List<Object[]> fields;

    static {
        BaseFont bfChinese;
        try {
            bfChinese = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H",
                    BaseFont.NOT_EMBEDDED);
            headfont = new Font(bfChinese, 24, Font.BOLD, BaseColor.BLACK);// 设置字体大小
            keyfont = new Font(bfChinese, 12, Font.BOLD, BaseColor.BLACK);// 设置字体大小
            textfont = new Font(bfChinese, 10, Font.NORMAL, BaseColor.BLACK);// 设置字体大小
        } catch (Exception e) {
            e.printStackTrace();
        }
    }


    /**
     * 对list数据源将其里面的数据导入到pdf表单
     *
     * @param list  导出数据集合
     * @param title 文件表头名称
     * @return 结果
     */
    public AjaxResult exportPdf(List<T> list, String title) throws Exception {
        this.init(list, title, Excel.Type.EXPORT);
        return exportPdf();
    }

    /**
     * 测试代码
     *
     * @param args
     * @throws Exception
     */
    public static void main(String[] args) throws Exception {
        //生成pdf数据
        List<String> header = new ArrayList<String>();
        PdfPTable table = PDFUtil.createTable(15);
        table.addCell(PDFUtil.createHeadCell("年后", 15));
        //测试表头
        for (int i = 0; i < 15; i++) {
            header.add("你好啊" + i);
            table.addCell(PDFUtil.createTitleCell_1("a" + i));
        }
        //测试数据
        for (int i = 0; i < 200; i++) {
            if (header != null && header.size() > 0) {
                for (String str : header) {
                    table.addCell(PDFUtil.createCell_1(str + "b"));
                }
            }
        }

//		输出流 由文件或response生成
        //临时文件名 用于水印操作
        //1、本地传输
        String output = "C:\\Users\\10910\\Desktop\\" + new SimpleDateFormat("mmsss").format(new Date()) + ".pdf";
        BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(new File(output)));

//		action和本地就out不同
//		HttpServletResponse response = null;
//		out = getOutputStream(response, fileName, "pdf");

        /**
         * 业务要求报表水印内容:客服中心报表系统,导出工号+工号
         */
        PDFUtil.exportPdf(out, table, "客服中心报表系统,导出工号969");


        System.out.println("完成");
    }


    public AjaxResult exportPdf() throws Exception {
        //生成pdf数据
        List<String> header = new ArrayList<String>();
        // 获取注解字段长度
        int length = fields.size();
        //创建一个PDF
        PdfPTable table = PDFUtil.createTable(length);
        table.addCell(PDFUtil.createHeadCell(this.title, length));

        for (Object[] os : fields) {
            Excel excel = (Excel) os[1];
            table.addCell(PDFUtil.createTitleCell_1(excel.name()));
        }
        if (Excel.Type.EXPORT.equals(type)) {
            table = fillPdfData(table);
        }
        String fileName = encodingFilename(this.title);
        String output = getAbsoluteFile(fileName);
        BufferedOutputStream out = new BufferedOutputStream(new FileOutputStream(new File(output)));
        PDFUtil.exportPdf(out, table, "");
        return AjaxResult.success(fileName);
    }

    /**
     * 编码文件名
     */
    public String encodingFilename(String filename) {
        filename = UUID.randomUUID().toString() + "_" + filename + ".pdf";
        return filename;
    }

    /**
     * 获取下载路径
     *
     * @param filename 文件名称
     */
    public String getAbsoluteFile(String filename) {
        String downloadPath = Global.getDownloadPath() + filename;
        File desc = new File(downloadPath);
        if (!desc.getParentFile().exists()) {
            desc.getParentFile().mkdirs();
        }
        return downloadPath;
    }

    /**
     * 填充Pdf数据
     *
     * @param table PdfPTable
     */
    public PdfPTable fillPdfData(PdfPTable table) {
        for (int i = 0; i < this.list.size(); i++) {
            // 得到导出对象.
            T vo = (T) list.get(i);
            for (Object[] os : fields) {
                Field field = (Field) os[0];
                Excel excel = (Excel) os[1];
                // 设置实体类私有属性可访问
                field.setAccessible(true);
                table = addCell(excel, table, vo, field);
            }
        }
        return table;
    }


    /**
     * 添加单元格
     */
    public PdfPTable addCell(Excel attr, PdfPTable table, T vo, Field field) {

        try {
            // 根据Excel中设置情况决定是否导出,有些情况需要保持为空,希望用户填写这一列.
            if (attr.isExport()) {

                // 用于读取对象中的属性
                Object value = getTargetValue(vo, field, attr);
                String dateFormat = attr.dateFormat();
                String readConverterExp = attr.readConverterExp();
                if (com.bims.common.utils.StringUtils.isNotEmpty(dateFormat) && com.bims.common.utils.StringUtils.isNotNull(value)) {
                    table.addCell(PDFUtil.createCell_1(DateUtils.parseDateToStr(dateFormat, (Date) value)));
                } else if (com.bims.common.utils.StringUtils.isNotEmpty(readConverterExp) && com.bims.common.utils.StringUtils.isNotNull(value)) {
                    table.addCell(PDFUtil.createCell_1(convertByExp(String.valueOf(value), readConverterExp)));
                } else {
                    // 设置列类型
                    if (Excel.ColumnType.STRING == attr.cellType()) {
                        table.addCell(PDFUtil.createCell_1(com.bims.common.utils.StringUtils.isNull(value) ? attr.defaultValue() : value + attr.suffix()));
                    } else if (Excel.ColumnType.NUMERIC == attr.cellType()) {
                        table.addCell(PDFUtil.createCell_1(value + ""));
                    }
                }
            }
        } catch (Exception e) {
            log.error("导出PDF失败{}", e);
        }
        return table;
    }

    /**
     * 解析导出值 0=男,1=女,2=未知
     *
     * @param propertyValue 参数值
     * @param converterExp  翻译注解
     * @return 解析后值
     * @throws Exception
     */
    public static String convertByExp(String propertyValue, String converterExp) throws Exception {
        try {
            String[] convertSource = converterExp.split(",");
            for (String item : convertSource) {
                String[] itemArray = item.split("=");
                if (itemArray[0].equals(propertyValue)) {
                    return itemArray[1];
                }
            }
        } catch (Exception e) {
            throw e;
        }
        return propertyValue;
    }

    /**
     * 获取bean中的属性值
     *
     * @param vo    实体对象
     * @param field 字段
     * @param excel 注解
     * @return 最终的属性值
     * @throws Exception
     */
    private Object getTargetValue(T vo, Field field, Excel excel) throws Exception {
        Object o = field.get(vo);
        if (com.bims.common.utils.StringUtils.isNotEmpty(excel.targetAttr())) {
            String target = excel.targetAttr();
            if (target.indexOf(".") > -1) {
                String[] targets = target.split("[.]");
                for (String name : targets) {
                    o = getValue(o, name);
                }
            } else {
                o = getValue(o, target);
            }
        }
        return o;
    }

    /**
     * 以类的属性的get方法方法形式获取值
     *
     * @param o
     * @param name
     * @return value
     * @throws Exception
     */
    private Object getValue(Object o, String name) throws Exception {
        if (com.bims.common.utils.StringUtils.isNotEmpty(name)) {
            Class<?> clazz = o.getClass();
            String methodName = "get" + name.substring(0, 1).toUpperCase() + name.substring(1);
            Method method = clazz.getMethod(methodName);
            o = method.invoke(o);
        }
        return o;
    }

    public void init(List<T> list, String title, Excel.Type type) {
        if (list == null) {
            list = new ArrayList<T>();
        }
        this.list = list;
        this.title = title;
        this.type = type;
        createExcelField();
    }

    /**
     * 得到所有定义字段
     */
    private void createExcelField() {
        this.fields = new ArrayList<Object[]>();
        List<Field> tempFields = new ArrayList<>();
        tempFields.addAll(Arrays.asList(clazz.getSuperclass().getDeclaredFields()));
        tempFields.addAll(Arrays.asList(clazz.getDeclaredFields()));
        for (Field field : tempFields) {
            // 单注解
            if (field.isAnnotationPresent(Excel.class)) {
                putToField(field, field.getAnnotation(Excel.class));
            }

            // 多注解
            if (field.isAnnotationPresent(Excels.class)) {
                Excels attrs = field.getAnnotation(Excels.class);
                Excel[] excels = attrs.value();
                for (Excel excel : excels) {
                    putToField(field, excel);
                }
            }
        }
    }

    /**
     * 放到字段集合中
     */
    private void putToField(Field field, Excel attr) {
        if (attr != null && (attr.type() == Excel.Type.ALL || attr.type() == type)) {
            this.fields.add(new Object[]{field, attr});
        }
    }


    // 表格表头样式1
    public static PdfPCell createTitleCell_1(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, keyfont));
        cell.setBackgroundColor(new BaseColor(29, 181, 238));
        // cell.setColspan(1);
        // cell.setFixedHeight(35);
        return cell;
    }

    // 表格表头样式2
    public static PdfPCell createTitleCell_2(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, keyfont));
        cell.setBackgroundColor(new BaseColor(29, 181, 238));
        cell.setColspan(1);
        cell.setRowspan(3);
        cell.setFixedHeight(105);
        return cell;
    }

    // 表格内容样式1
    public static PdfPCell createCell_1(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, textfont));
        cell.setBackgroundColor(new BaseColor(255, 255, 255));
        cell.setColspan(1);
//		cell.setFixedHeight(35);
        return cell;
    }

    // 表格内容样式2
    public static PdfPCell createCell_2(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, textfont));
        cell.setBackgroundColor(new BaseColor(255, 255, 255));
        cell.setColspan(1);
        cell.setRowspan(3);
        cell.setFixedHeight(105);
        return cell;
    }

    // 表格内容样式3
    public static PdfPCell createCell_3(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, textfont));
        cell.setBackgroundColor(new BaseColor(255, 255, 255));
        cell.setColspan(2);
        cell.setFixedHeight(35);
        return cell;
    }

    // 表格内容样式4
    public static PdfPCell createCell_4(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, textfont));
        cell.setBackgroundColor(new BaseColor(255, 255, 255));
        cell.setColspan(4);
        cell.setRowspan(3);
        cell.setFixedHeight(105);
        return cell;
    }

    // 生成表格
    public static PdfPTable createTable(int colNumber) {
        // int widths[] = { 35,40,35,35,30 };
        int widths[] = new int[colNumber];
        for (int i = 0; i < widths.length; i++) {
            widths[i] = 35 * 5 / colNumber;
        }
        PdfPTable baseTable = new PdfPTable(colNumber);
        baseTable.setWidthPercentage(100);
        baseTable.setSpacingBefore(10);
        try {
            baseTable.setWidths(widths);
        } catch (DocumentException e) {
            e.printStackTrace();
        }
        return baseTable;
    }

    /**
     * @param input   临时文件地址
     * @param out     当浏览器下载时 :BufferedOutputStream out = getOutputStream(response, fileName, "pdf");
     *                本地测试时:
     *                String output = "C:\\Users\\jinyu\\Desktop\\pdf\\"+new SimpleDateFormat("mmsss").format(new Date())+".pdf";
     *                BufferedOutputStream out = new BufferedOutputStream( new FileOutputStream(new File(output)));
     * @param imgPath 水印图片地址 空时不添加水印
     * @param texMark 水印文字 空时不添加水印
     * @throws Exception
     */
    public static void addmark(String input, BufferedOutputStream out,
                               String imgPath, String texMark) throws Exception {
        try {
            PdfReader reader = new PdfReader(input);
            PdfStamper stamper = new PdfStamper(reader, out);
//			不允许编辑 打印 ======
            byte[] ownerPassword = UUID.randomUUID().toString().replaceAll("-", "").getBytes();
            stamper.setEncryption(null, ownerPassword, PdfWriter.ALLOW_COPY, PdfWriter.ENCRYPTION_AES_128);
            if (StringUtils.isNotEmpty(imgPath)) {
                addPageMark(imgPath, reader, stamper);
            }
            if (StringUtils.isNotEmpty(texMark)) {
                addWatermark(stamper, texMark);
            }
            stamper.close();
            reader.close();
            File file = new File(input);
            if (file.exists()) {
                file.delete();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void addmark(String input, BufferedOutputStream out, String texMark) throws Exception {
        addmark(input, out, "", texMark);
    }

    /**
     * 添加图片水印
     *
     * @param realPath
     * @param reader
     * @param stamper
     */
    public static void addPageMark(String realPath, PdfReader reader,
                                   PdfStamper stamper) {
        int total = reader.getNumberOfPages();
        try {
            Image image = Image.getInstance(realPath);
            image.setAbsolutePosition(350, 200);
            image.scaleToFit(160, 70);
            PdfContentByte content = stamper.getOverContent(total);// 在内容上方加水印
            content.addImage(image);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }


    public static void addWatermark(PdfStamper pdfStamper, String waterMarkName)
            throws Exception {
        PdfContentByte content;
        BaseFont base = BaseFont.createFont("STSong-Light", "UniGB-UCS2-H",
                BaseFont.NOT_EMBEDDED);
        Rectangle pageRect;
        PdfGState gs = new PdfGState();
        try {
            if (base == null || pdfStamper == null) {
                return;
            }
            // 设置透明度为0.4
            gs.setFillOpacity(0.3f);
            gs.setStrokeOpacity(0.3f);
            int toPage = pdfStamper.getReader().getNumberOfPages();
            for (int i = 1; i <= toPage; i++) {
                pageRect = pdfStamper.getReader().getPageSizeWithRotation(i);
                // 计算水印X,Y坐标
                // 获得PDF最顶层
                content = pdfStamper.getOverContent(i);
                content.saveState();
                // set Transparency
                content.setGState(gs);
                content.beginText();
                content.setColorFill(BaseColor.GRAY);
                content.setFontAndSize(base, 20);
                // 水印文字成45度角倾斜
//				float x = pageRect.getWidth() / 2;
//				float y = pageRect.getHeight() / 2;
                int hnum = 4;
                int wnum = 4;
                float h = pageRect.getHeight() / hnum;
                float w = pageRect.getWidth() / wnum;
                for (int k = 1; k < hnum; k++) {
                    for (int j = 1; j < wnum; j++) {
                        content.showTextAligned(Element.ALIGN_CENTER, waterMarkName, w * j, k * h, 45);
                    }
                }
                content.endText();
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    // =============================
    // 表格标题
    public static PdfPCell createHeadCell(String value, int number) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(15);
        cell.setHorizontalAlignment(15);
        // 合并5列
        cell.setColspan(number);
        cell.setPhrase(new Phrase(value, headfont));
        cell.setHorizontalAlignment(Element.ALIGN_CENTER); // 水平居中
        cell.setPadding(10.0f);
        cell.setBorder(0);
        cell.setPaddingTop(5.0f);
        cell.setPaddingBottom(18.0f);
        return cell;
    }

    // 表格内容样式1
    public static PdfPCell createCell(String value) {
        PdfPCell cell = new PdfPCell();
        cell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        cell.setHorizontalAlignment(Element.ALIGN_CENTER);
        cell.setPhrase(new Phrase(value, textfont));
        cell.setBackgroundColor(new BaseColor(255, 255, 255));
        cell.setColspan(1);
        // cell.setRowspan(3);
        // cell.setFixedHeight(105);
        cell.setFixedHeight(35);
        return cell;
    }

    // ============================================样式设置

    // ============================================导出 设置=======================

    /**
     * @param out       本地:
     *                  String output = "C:\\Users\\jinyu\\Desktop\\pdf\\"+new SimpleDateFormat("mmsss").format(new Date())+".pdf";
     *                  BufferedOutputStream out =  new BufferedOutputStream( new FileOutputStream(new File(output)));
     *                  action :
     *                  参考 注释 getOutputStream
     * @param pdfPTable 数据
     * @param realPath  水印图片地址
     * @param texmark   水印文字
     * @throws IOException
     * @throws Exception
     */
    public static void exportPdf(BufferedOutputStream out,
                                 PdfPTable pdfPTable, String realPath, String texmark)
            throws IOException, Exception {
        String lsfile = setTableData(pdfPTable);
//		BufferedOutputStream out = getOutputStream(response, fileName, "pdf");
        try {
            PDFUtil.addmark(lsfile, out, realPath, texmark);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (out != null) {
                out.close();
            }
        }
    }

    //不含水印图片
    public static void exportPdf(BufferedOutputStream out,
                                 PdfPTable pdfPTable, String texmark)
            throws IOException, Exception {
        String lsfile = setTableData(pdfPTable);
        try {
            PDFUtil.addmark(lsfile, out, "", texmark);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (out != null) {
                out.close();
            }
        }
    }


    public static void setTableData(PdfPTable table, OutputStream outputStream) {

        try {
            Document document = new Document();// 建立一个Document对象
            Rectangle pageSize = new Rectangle(PageSize.A4.getHeight(), PageSize.A4.getWidth());
            pageSize.rotate();
            document.setPageSize(pageSize);
            PdfWriter writer = PdfWriter.getInstance(document, outputStream);
            PDFBuilder builder = new PDFBuilder();
            writer.setPageEvent(builder);
            document.open();
            document.add(table);
            document.close();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (outputStream != null) {
                try {
                    outputStream.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    public static String setTableData(PdfPTable table) {
        String out = UUID.randomUUID().toString().replaceAll("-", "") + ".pdf";
        FileOutputStream fileIo = null;
        try {
            Document document = new Document();// 建立一个Document对象
            Rectangle pageSize = new Rectangle(PageSize.A4.getHeight(), PageSize.A4.getWidth());
            pageSize.rotate();
            document.setPageSize(pageSize);
            fileIo = new FileOutputStream(out);
            PdfWriter writer = PdfWriter.getInstance(document, fileIo);
            PDFBuilder builder = new PDFBuilder();
            writer.setPageEvent(builder);
            document.open();
            document.add(table);
            document.close();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (fileIo != null) {
                try {
                    fileIo.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
        return out;
    }

    /**
     * 获取需要导出的数据 (简单的)
     *
     * @param list
     * @param search
     * @param header
     * @return
     */
    public static PdfPTable getPdfPTable(List<List<String>> list, String search, List<String> header) {
        int size = header.size();
        // 设置列数
        PdfPTable table = createPdfPTable(size);
        // 设置查询条件
        setPdfPTableSearch(table, search, size);
        // 添加表头数据
        setPdfPTableSimpleHead(table, header);
        setPdfPTableSimpleData(table, list);
        return table;
    }

    // 1、创建 PdfPTable
    public static PdfPTable createPdfPTable(int size) {
        PdfPTable table = PDFUtil.createTable(size);
        return table;
    }

    // 2 、 设置查询条件
    public static PdfPTable setPdfPTableSearch(PdfPTable table, String search,
                                               int size) {
        table.addCell(PDFUtil.createHeadCell(search, size));
        return table;
    }

    // 3 、1 设置 简单表头
    public static PdfPTable setPdfPTableSimpleHead(PdfPTable table, List<String> header) {
        if (header != null && header.size() > 0) {
            for (String str : header) {
                table.addCell(PDFUtil.createCell_1(str));
            }
        }
        return table;
    }

    /**
     * 3 、2 设置 复杂表头
     */
//	public static PdfPTable setPdfPTableComplexHead(PdfPTable table, List<List<ComplexParams>> list) {
//		if (list != null && list.size() > 0) {
//			for (List<ComplexParams> ls : list) {
//				if (ls != null && ls.size() > 0) {
//					for (ComplexParams one : ls) {
//						String name = one.getName();
//						PdfPCell cell = PDFUtil.createCell(name);
//						cell.setColspan(getInt(one.getColspan()));
//						cell.setRowspan(getInt(one.getRowspan()));
//						table.addCell(cell);
//					}
//				}
//			}
//		}
//		return table;
//	}

    // 4.1 设置简单数据
    public static PdfPTable setPdfPTableSimpleData(PdfPTable table, List<List<String>> list) {
        if (list != null && list.size() > 0) {
            for (List<String> ls : list) {
                if (ls != null && ls.size() > 0) {
                    for (String str : ls) {
                        table.addCell(PDFUtil.createCell_1(str));
                    }
                }
            }
        }
        return table;
    }

    /**
     * 4.2 设置合并数据
     *
     * @param table   数据PdfPTable
     * @param list    数据主题
     * @param coIndex 合并注塑机所在列
     * @param cols    多少列
     * @param isrow   是否合并
     * @return
     */
    public static PdfPTable setPdfPTableMergeData(PdfPTable table, List<List<String>> list, int coIndex, int cols, List<Boolean> isrow) {
        List<PdfPCell> box = new ArrayList<PdfPCell>();
        int[] index = getIndex(new int[cols]);
        int rowspan = -1;
        if (list != null && list.size() > 0) {
            for (int i = 0; i < list.size(); i++) {
                List<String> list2 = list.get(i);
                if (list2 != null && list2.size() > 0) {
                    for (int j = 0; j < list2.size(); j++) {
                        String value = list2.get(j);
                        PdfPCell createCell = createCell(value);
                        Boolean boolean1 = isrow.get(j);
                        if (j == coIndex) {
                            int rowspan2 = getRowspan(list, i, j, value, 0, true);
                            //System.out.println(value);
                            //System.out.println("rowspan2--"+rowspan2);
                            //第一次调用
                            if (rowspan == -1) {
                                if (rowspan2 == 1) {
                                    table.addCell(createCell);
                                    rowspan = 1;
                                } else {
                                    rowspan = rowspan2;
                                    index[j] = i + rowspan2 - 1;
                                    createCell.setRowspan(rowspan2);
                                    createCell.setFixedHeight(rowspan2 * 35);
                                    box.add(createCell);
                                }
                            } else if (rowspan == 1) {
                                if (rowspan2 == 1) {
                                    table.addCell(createCell);
                                    rowspan = 1;
                                } else {
                                    rowspan = rowspan2;
                                    index[j] = i + rowspan2 - 1;
                                    createCell.setRowspan(rowspan2);
                                    createCell.setFixedHeight(rowspan2 * 35);
                                    box.add(createCell);
                                }
                            } else {
                                int l = index[j];
                                if (l == -1) {
                                    if (rowspan2 == 1) {
                                        table.addCell(createCell);
                                    } else {
                                        index[j] = i + rowspan2 - 1;
                                        createCell.setRowspan(rowspan2);
                                        createCell.setFixedHeight(rowspan2 * 35);
                                        box.add(createCell);
                                    }
                                } else {
//									if(i==index[j]){
//										index[j] = -1;
//									}
                                }
                            }
                        } else if (j > coIndex) {
                            if (boolean1) {
                                if (rowspan <= 1) {
                                    table.addCell(createCell);
                                } else {
                                    int l = index[j];
                                    int rowspan2 = getRowspan(list, i, j, value, rowspan, false);
                                    if (l == -1) {
                                        if (rowspan2 == 1) {
                                            box.add(createCell);
                                        } else {
                                            index[j] = i + rowspan2 - 1;
                                            createCell.setRowspan(rowspan2);
                                            createCell.setFixedHeight(rowspan2 * 35);
                                            box.add(createCell);
                                        }
                                    } else {
                                        if (i == index[j]) {
                                            index[j] = -1;
                                        }
                                    }
                                }
                            } else {
                                if (rowspan <= 1) {
                                    table.addCell(createCell);
                                } else {
                                    box.add(createCell);
                                }

                            }

                            //到最后一列
                            if (index[coIndex] == i && j == list2.size() - 1) {
                                index = getIndex(index);
                                if (box != null && box.size() > 0) {
                                    for (int k = 0; k < box.size(); k++) {
                                        PdfPCell pdfPCell = box.get(k);
                                        table.addCell(pdfPCell);
                                        ;
                                    }
                                }
                                //重置
                                box = new ArrayList<PdfPCell>();
                                rowspan = -1;
                            }

                        } else {
                            if (rowspan <= 1) {
                                table.addCell(createCell);
                            } else {
                                box.add(createCell);
                            }
                        }
                    }
                }

            }
        }
        return table;
    }

    private static int[] getIndex(int[] index) {
        for (int i = 0; i < index.length; i++) {
            index[i] = -1;
        }
        return index;
    }

    /**
     * 行列的值最少是1
     *
     * @param str
     * @return
     */
    public static int getInt(String str) {
        int re = 1;
        try {
            re = Integer.parseInt(str);
        } catch (Exception e) {
        }
        return re;
    }

    /**
     * @param list  数据
     * @param hang  第几行
     * @param lie   第几列
     * @param value 当前列的值
     * @param limit 第一行合并数
     * @param fla   是否是第一行
     * @return
     */
    public static int getRowspan(List<List<String>> list, int hang, int lie, String value, int limit, boolean fla) {
        int coun = 1;
        for (int i = hang + 1; i < list.size(); i++) {
            String check = "";
            List<String> list2 = list.get(i);
            if (list2 != null && list2.size() > 0) {
                if (StringUtils.isNotEmpty(list2.get(lie))) {
                    check = list2.get(lie);
                }
            }
            if (value.endsWith(check)) {
                coun++;
            } else {
                if (!fla && coun > limit) {
                    coun = limit;
                }
                return coun;
            }
        }
        if (!fla && coun > limit) {
            coun = limit;
        }
        return coun;
    }
}

4.使用方式

PDFUtil<实体类> util = new PDFUtil<实体类>(实体类.class);
return util.exportPdf(list, "文件名称");
  • 3
    点赞
  • 26
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 18
    评论
在Java中,您可以使用EasyExcel库来导出多个sheet页,并且可以使用@Excel注解来指定导出的数据的字段和表头信息。下面是一个样例代码,用于演示如何使用@Excel注解导出多个sheet页: ```java // 定义一个导出数据的实体类 public class ExportData { @ExcelProperty("姓名") private String name; @ExcelProperty("年龄") private Integer age; // 其他属性... } // 导出多个sheet页的方法 public void exportDataToExcel(String filename) { // 创建导出数据 List<ExportData> dataList1 = new ArrayList<>(); dataList1.add(new ExportData("张三", 20)); dataList1.add(new ExportData("李四", 22)); List<ExportData> dataList2 = new ArrayList<>(); dataList2.add(new ExportData("王五", 25)); dataList2.add(new ExportData("赵六", 27)); // 使用 EasyExcel 进行导出 ExcelWriter writer = EasyExcel.write(filename).build(); WriteSheet sheet1 = EasyExcel.writerSheet(0, "Sheet1").head(ExportData.class).build(); WriteSheet sheet2 = EasyExcel.writerSheet(1, "Sheet2").head(ExportData.class).build(); writer.write(dataList1, sheet1); writer.write(dataList2, sheet2); writer.finish(); } ``` 在这个代码中,我们先定义了一个导出数据实体类ExportData,然后使用EasyExcel库进行导出。我们创建了两个sheet页,分别对应两个导出数据列表dataList1和dataList2。使用@ExcelProperty注解来指定每个字段对应的表头信息。最后使用ExcelWriter将数据写入Excel文件中,使用WriteSheet来指定每个sheet页的名称和表头信息。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 18
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

不会写爬虫的程序员B

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值