<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.pdf</artifactId>
        <version>12.9.0</version>
    </dependency>
</dependencies>

import com.spire.pdf.*;
import com.spire.pdf.graphics.PdfMargins;

public class InsertEmptyPage {
    public static void main(String[] args) {
        //创建一个PdfDocument实例
        PdfDocument pdf = new PdfDocument();

        //加载一个样本PDF文档
        pdf.loadFromFile("C:\\Users\\Test1\\Desktop\\sample.pdf");

        //将空白页插入文档作为第二页
        pdf.getPages().insert(1);

        //添加一个空白页到文档末尾
        pdf.getPages().add(PdfPageSize.A4, new PdfMargins(0, 0));

        //将文档保存到另一个文件
        pdf.saveToFile("output/insertEmptyPage.pdf");
        pdf.close();
    }
}

import com.spire.pdf.*;

public class DeletePage {
    public static void main(String[] args) {

        //创建一个PdfDocument实例
        PdfDocument pdf = new PdfDocument();

        //加载一个样本PDF文档
        pdf.loadFromFile("C:\\Users\\Test1\\Desktop\\sample.pdf");

        //删除文档的第二页
        pdf.getPages().removeAt(1);

        //将文档保存到另一个文件
        pdf.saveToFile("output/deletePage.pdf");
        pdf.close();
    }
}

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>16.9.2</version>
    </dependency>
</dependencies>

import com.spire.xls.Workbook;

public class ExcelToOpenXML {
    public static void main(String []args){
        //创建一个Workbook实例
        Workbook workbook = new Workbook();
        //加载Excel文件
        workbook.loadFromFile("Sample.xlsx");

        //保存为Office Open XML文件格式
        workbook.saveAsXml("ToXML.xml");
    }
}

import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;

public class OpenXmlToExcel {
    public static void main(String []args){
        //创建一个Workbook实例
        Workbook workbook = new Workbook();
        //加载Office Open XML文件
        workbook.loadFromXml("ToXML.xml");

        //保存为Excel XLSX文件格式
        workbook.saveToFile("ToExcel.xlsx", ExcelVersion.Version2016);
    }
}

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.pdf</artifactId>
        <version>12.9.0</version>
    </dependency>
</dependencies>

import com.spire.pdf.PdfDocument;
import com.spire.pdf.PdfPageBase;
import com.spire.pdf.graphics.PdfImageType;

import java.awt.*;
import java.awt.image.BufferedImage;

public class removeBlankPages {
    public static void main(String []args){

        //创建 PdfDocument 类的对象
        PdfDocument pdf = new PdfDocument();

        //载入PDF文件
        pdf.loadFromFile("C:/Sample.pdf");

        BufferedImage image;
        //循环遍历PDF中的页面
        for(int i = pdf.getPages().getCount()-1; i>=0; i--)
        {
            //获取页面
            PdfPageBase page = pdf.getPages().get(i);
            //检测页面是否完全空白
            if(page.isBlank())
            {
                //删除完全空白的页面
                pdf.getPages().remove(page);
            }
            else
            {
                //将页面转换为图片
                image = pdf.saveAsImage(i, PdfImageType.Bitmap);

                //检测转换出的图片是否为空白图片
                if (isBlankImage(image))
                {
                    //删除空白图片所对应的页面
                    pdf.getPages().remove(page);
                }
            }

        }

        //保存结果文档
        pdf.saveToFile("删除空白页面.pdf");
    }

    //检测图片是否为空白图片
    public static boolean isBlankImage(BufferedImage image)
    {
        BufferedImage bufferedImage = image;

        Color pixel;
        for (int i = 0; i < bufferedImage.getWidth(); i++)
        {
            for (int j = 0; j < bufferedImage.getHeight(); j++)
            {
                pixel = new Color(bufferedImage.getRGB(i, j));
                if (pixel.getRed() < 240 || pixel.getGreen() < 240 || pixel.getBlue() < 240)
                {
                    return false;
                }
            }
        }
        return true;
    }
}

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>16.9.2</version>
    </dependency>
</dependencies>

import com.spire.xls.*;

public class OperateWPSExcel {
    public static void main(String[] args) {
        //创建Workbook类的对象
        Workbook workbook = new Workbook();

        //加载WPS表格文档
        workbook.loadFromFile("test.et");//支持.ett格式

        //获取第一个工作表
        Worksheet sheet = workbook.getWorksheets().get(0);

        //向工作表的指定单元格填充数据
        sheet.getCellRange("B4").setText("办公桌");
        sheet.getCellRange("C4").setText("台");
        sheet.getCellRange("D4").setText("800");
        sheet.getCellRange("E4").setText("6");
        sheet.getCellRange("F4").setText("4800");

        //设置单元格居中对齐效果
        sheet.getCellRange("B4:F4").setHorizontalAlignment(HorizontalAlignType.Center);

        //保存文档为.et格式
        workbook.saveToFile("Result.et", FileFormat.ET);
        //保存文档为.ett格式
        //wb.saveToFile("WPS.ett", FileFormat.ETT);
    }
}

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.cn/repository/maven-public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.office</artifactId>
        <version>11.9.0</version>
    </dependency>
</dependencies>

import com.spire.doc.*;
import com.spire.doc.documents.PageOrientation;
import com.spire.xls.*;

public class xlsTest {
    public static void main(String[] args) {
        //下载一个Excel文件
        Workbook workbook = new Workbook();
        workbook.loadFromFile("C:/Users/Administrator/Desktop/sample.xlsx");

        //得到第一张工作表
        Worksheet sheet = workbook.getWorksheets().get(0);

        //创建一个Word文档
        Document doc = new Document();
        Section section = doc.addSection();
        section.getPageSetup().setOrientation(PageOrientation.Landscape);

        //添加一个表格
        Table table = section.addTable(true);
        table.resetCells(sheet.getLastRow(), sheet.getLastColumn());

        //合并单元格
        mergeCells(sheet, table);

        for (int r = 1; r <= sheet.getLastRow(); r++) {

            //设置行高
            table.getRows().get(r - 1).setHeight((float) sheet.getRowHeight(r));

            for (int c = 1; c <= sheet.getLastColumn(); c++) {
                CellRange xCell = sheet.getCellRange(r, c);
                TableCell wCell = table.get(r - 1, c - 1);

                //获得特定Excel单元格的值并将其添加到Word表格单元格
                TextRange textRange = wCell.addParagraph().appendText(xCell.getValue());

                // 从Excel复制字体和单元格样式到Word
                copyStyle(textRange, xCell, wCell);
            }
        }

        //保存文档为Word文件
        doc.saveToFile("ExportToWord.docx", FileFormat.Docx);
    }
    //如果有合并的区域，则合并单元格
    private static void mergeCells(Worksheet sheet, Table table) {
        if (sheet.hasMergedCells()) {

            //从Excel中获取合并的单元格范围
            CellRange[] ranges = sheet.getMergedCells();
            for (int i = 0; i < ranges.length; i++) {
                int startRow = ranges[i].getRow();
                int startColumn = ranges[i].getColumn();
                int rowCount = ranges[i].getRowCount();
                int columnCount = ranges[i].getColumnCount();

                //合并Word表格中的对应单元格
                if (rowCount > 1 && columnCount > 1) {
                    for (int j = startRow; j <= startRow + rowCount; j++) {
                        table.applyHorizontalMerge(j - 1, startColumn - 1, startColumn - 1 + columnCount - 1);
                    }
                    table.applyVerticalMerge(startColumn - 1, startRow - 1, startRow - 1 + rowCount - 1);
                }
                if (rowCount > 1 && columnCount == 1) {
                    table.applyVerticalMerge(startColumn - 1, startRow - 1, startRow - 1 + rowCount - 1);
                }
                if (columnCount > 1 && rowCount == 1) {
                    table.applyHorizontalMerge(startRow - 1, startColumn - 1, startColumn - 1 + columnCount - 1);
                }
            }
        }
    }
    //复制Excel单元格样式到Word表格
    private static void copyStyle(TextRange wTextRange, CellRange xCell, TableCell wCell) {

        //复制字体样式
        wTextRange.getCharacterFormat().setTextColor(xCell.getStyle().getFont().getColor());
        wTextRange.getCharacterFormat().setFontSize((float) xCell.getStyle().getFont().getSize());
        wTextRange.getCharacterFormat().setFontName(xCell.getStyle().getFont().getFontName());
        wTextRange.getCharacterFormat().setBold(xCell.getStyle().getFont().isBold());
        wTextRange.getCharacterFormat().setItalic(xCell.getStyle().getFont().isItalic());

        //复制背景色
        wCell.getCellFormat().getShading().setBackgroundPatternColor(xCell.getStyle().getColor());

        //复制水平对齐方式
        switch (xCell.getHorizontalAlignment()) {
            case Left:
                wTextRange.getOwnerParagraph().getFormat().setHorizontalAlignment(HorizontalAlignment.Left);
                break;
            case Center:
                wTextRange.getOwnerParagraph().getFormat().setHorizontalAlignment(HorizontalAlignment.Center);
                break;
            case Right:
                wTextRange.getOwnerParagraph().getFormat().setHorizontalAlignment(HorizontalAlignment.Right);
                break;
        }

        //复制垂直对齐方式
        switch (xCell.getVerticalAlignment()) {
            case Bottom:
                wCell.getCellFormat().setVerticalAlignment(VerticalAlignment.Bottom);
                break;
            case Center:
                wCell.getCellFormat().setVerticalAlignment(VerticalAlignment.Middle);
                break;
            case Top:
                wCell.getCellFormat().setVerticalAlignment(VerticalAlignment.Top);
                break;
        }
    }
}