以下经验介绍如何通过Java程序打印Excel工作表。可通过以下方法打印：1.默认打印机打印2.指定打印机打印
工具/原料
Spire.XLSforJava
JDK1.8.0
IDEA
Jar文件导入:
1、方法1：在E-iceblue中文官网下载jar包，解压导入Spire.Xls.jar（jar在lib文件夹下）方法2：Maven程序中导入jar需要先配置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。如下jar导入效果：
Java代码
1、1.咯悝滩镞默认打印机打印importcom.spire.xls.*;importjava.awt.print.PageFormat;importjava.锾攒揉敫awt.print.Paper;importjava.awt.print.PrinterException;importjava.awt.print.PrinterJob;publicclassPrint{publicstaticvoidmain(String[]args){//加载excel工作簿Workbookworkbook=newWorkbook();workbook.loadFromFile("test.xlsx");//创建PrinterJob对象PrinterJobprinterJob=PrinterJob.getPrinterJob();//指定打印页面为默认大小和方向PageFormatpageFormat=printerJob.defaultPage();//设置相关打印选项Paperpaper=pageFormat.getPaper();paper.setImageableArea(0,0,pageFormat.getWidth(),pageFormat.getHeight());pageFormat.setPaper(paper);printerJob.setCopies(1);printerJob.setPrintable(workbook,pageFormat);//执行打印try{printerJob.print();}catch(PrinterExceptione){e.printStackTrace();}}}
2、2.依宏氽墓指定打印机打印importcom.spire.xls.*;importjavax.print.Pr足毂忍珩intService;importjava.awt.print.PageFormat;importjava.awt.print.Paper;importjava.awt.print.PrinterException;importjava.awt.print.PrinterJob;publicclassPrint{publicstaticvoidmain(String[]args)throwsException{//加载excel工作表Workbookworkbook=newWorkbook();workbook.loadFromFile("test.xlsx");//创建PrinterJob对象PrinterJobprinterJob=PrinterJob.getPrinterJob();//指定打印机PrintServicemyPrintService=findPrintService("\\\\192.168.1.104\\HPLaserJetP1007");printerJob.setPrintService(myPrintService);//指定打印页面为默认大小和方向PageFormatpageFormat=printerJob.defaultPage();//设置相关打印选项Paperpaper=pageFormat.getPaper();paper.setImageableArea(0,0,pageFormat.getWidth(),pageFormat.getHeight());pageFormat.setPaper(paper);printerJob.setCopies(1);printerJob.setPrintable(workbook,pageFormat);//执行打印try{printerJob.print();}catch(PrinterExceptione){e.printStackTrace();}}//通过打印机名称获取打印服务privatestaticPrintServicefindPrintService(StringprinterName){PrintService[]printServices=PrinterJob.lookupPrintServices();for(PrintServiceprintService:printServices){if(printService.getName().equals(printerName)){returnprintService;}}returnnull;}}