Java 打印Excel工作表

我就是我 2022-12-22 09:20 150阅读 0赞

### **示例要点** ###

本文介绍如何通过Java程序打印Excel工作表。可通过以下方法打印：

1.  默认打印机打印
2.  指定打印机打印

### **程序环境** ###

1.  spire.xls.jar
2.  JDK版本要求1.6.0及以上的高版本
3.  IDEA

### **Jar****文件导入** ###

**方法1**：手动下载jar包导入。下载*[jar包][jar]*，并解压到指定路径，将该路径下lib文件夹下的jar文件导入java程序；

**方法2**：*[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</artifactId>
      <version>3.11.2</version>
    </dependency>
    </dependencies>

完成配置后，导入jar。Eclipse中的导入方法可参考教程*[文档][Link 1]*。

jar导入效果图：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0VpY2VibHVl_size_16_color_FFFFFF_t_70][]

### **Java****代码** ###

**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 Print {
        public static void main(String[] args) {
            //加载excel工作簿
            Workbook workbook = new Workbook();
            workbook.loadFromFile("test.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 Print {
        public static void main(String[] args) throws Exception {
            //加载excel工作表
            Workbook workbook = new Workbook();
            workbook.loadFromFile("test.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;
        }
    }

**推荐阅读：**

*  Java 打印Word

1.  [Java 打印Word (1][Java _Word _1])
2.  [Java 打印Word (2][Java _Word _2])

*  [Java 打印PDF][Java _PDF]
 *  [Java 打印PPT][Java _PPT]

[jar]: https://www.e-iceblue.cn/Downloads/Spire-XLS-JAVA.html
[Maven]: http://repo.e-iceblue.cn/#browse/browse:maven-public
[Link 1]: https://www.e-iceblue.cn/licensing/install-spirepdf-for-java-from-maven-repository.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0VpY2VibHVl_size_16_color_FFFFFF_t_70]: /images/20221120/2d527f2f3a1543d79ae3cc0a48f99ef0.png
[Java _Word _1]: https://blog.csdn.net/Eiceblue/article/details/100983613
[Java _Word _2]: https://blog.csdn.net/Eiceblue/article/details/108661816
[Java _PDF]: https://blog.csdn.net/Eiceblue/article/details/87367107
[Java _PPT]: https://blog.csdn.net/Eiceblue/article/details/102898041