在日常工作或学习中，我们时常会碰到需要将制作好的Excel表格打印出来张贴到公告栏、工作区或下发分享给其他人的情况。这篇文章就将用Java代码来演示如何打印Excel工作表。打印可分为以下两种方式：

• 默认打印机打印

• 指定打印机打印

使用工具及Jar包导入

本教程使用到了Free Spire.XLS for Java控件。在运行代码前，需将控件中的Jar包导入IDEA。可通过E-iceblue中文官网下载产品包，找到包里的Spire.xls.jar，然后手动进行导入；也可创建Maven仓库，然后在pom.xml文件下添加以下引用进行导入。

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

代码示例

示例 1 默认打印机打印

import com.spire.xls.*;
import java.awt.print.PageFormat;
import java.awt.print.Paper;
import java.awt.print.PrinterException;
import java.awt.print.PrinterJob;

public class PrintByDefault {
    public static void main(String[] args) {
        //加载excel工作簿
        Workbook workbook = new Workbook();
        workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\Sample.xlsx");

        //创建 PrinterJob对象
        PrinterJob printerJob = PrinterJob.getPrinterJob();

        //指定打印页面为默认大小和方向
        PageFormat pageFormat = printerJob.defaultPage();

        //设置相关打印选项
        Paper paper = pageFormat.getPaper();
        paper.setImageableArea(0, 0, pageFormat.getWidth(), pageFormat.getHeight());
        pageFormat.setPaper(paper);
        printerJob.setCopies(1);
        printerJob.setPrintable(workbook, pageFormat);

        //执行打印
        try {
            printerJob.print();
        } catch (PrinterException e) {
            e.printStackTrace();
        }
    }
}

示例 2 指定打印机打印

import com.spire.xls.*;
import javax.print.PrintService;
import java.awt.print.PageFormat;
import java.awt.print.Paper;
import java.awt.print.PrinterException;
import java.awt.print.PrinterJob;

public class SpecifiedPrinter {
    public static void main(String[] args) throws PrinterException {
        //加载excel工作表
        Workbook workbook = new Workbook();
        workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\Sample.xlsx");

        //创建 PrinterJob对象
        PrinterJob printerJob = PrinterJob.getPrinterJob();

        //指定打印机
        PrintService myPrintService = findPrintService("\\\\192.168.1.104\\HP LaserJet P1007");
        printerJob.setPrintService( myPrintService);

        //指定打印页面为默认大小和方向
        PageFormat pageFormat = printerJob.defaultPage();

        //设置相关打印选项
        Paper paper = pageFormat.getPaper();
        paper.setImageableArea(0, 0, pageFormat.getWidth(), pageFormat.getHeight());
        pageFormat.setPaper(paper);
        printerJob.setCopies(1);
        printerJob.setPrintable(workbook, pageFormat);

        //执行打印
        try {
            printerJob.print();
        } catch (PrinterException e) {
            e.printStackTrace();
        }
    }

    //通过打印机名称获取打印服务
    private static PrintService findPrintService(String printerName) {
        PrintService[] printServices = PrinterJob.lookupPrintServices();
        for (PrintService printService : printServices) {
            if (printService.getName().equals(printerName)) {
                return printService;
            }
        }
        return null;
    }
}