Shulou(Shulou.com)06/01 Report--

This article mainly explains the "Java to achieve Excel to PDF methods there are", the article explained the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "what are the Java Excel to PDF methods?"

First, use spire to convert PDF

First of all, this paper introduces a relatively simple method, which can convert a certain sheet page or the entire Excel file in our Excel file to PDF format with just a few lines of code.

But one disadvantage of this method is that the jar package is free and can only export 3 sheet pages, which is not suitable for the conversion of Excel files with multiple sheet pages.

When using it, first import the required dependencies of workbook in the pom file:

E-iceblue spire.xls.free 2.2.01. Use spire to convert the entire Excel file to PDF

It only takes two steps to export the code for the entire Excel file using workbook, so we can look directly at the code example:

/ * use spire to simply convert the entire Excel to pdf * * @ param inputFilePath Excel file path * @ param outputFilePath exported PDF file path * / public static void totalExcelToPDF (String inputFilePath, String outputFilePath) {Workbook wb = new Workbook (); / / introduce the Excel file wb.loadFromFile (inputFilePath) / / Export PDF file wb.saveToFile (outputFilePath, FileFormat.PDF);} 2. Specify a single sheet page to PDF

Using spire, you can output a specified single sheet page into PDF format, where you need to enter the subscript of the specified sheet page. The code example is as follows:

/ * use spire to convert a single sheet to a pdf * * @ param inputFilePath Excel file path * @ param outputFilePath exported PDF file path * @ param sheetNum exported sheet page subscript * / public static void partExcelToPDF (String inputFilePath, String outputFilePath, int sheetNum) {/ / load Excel document Workbook wb = new Workbook (); wb.loadFromFile (inputFilePath) / / get which sheet page Worksheet sheet = wb.getWorksheets () .get (sheetNum); / / call the method to save in PDF format sheet.saveToPdf (outputFilePath);}

The above method of using spire to achieve Excel conversion PDF is simple, but it is not suitable for larger Excel file conversion and is only suitable for files with less than 3 sheet pages.

So in enterprise project development, if you want to convert a large number of Excel files or Excel files with more sheet pages into PDF format, it is recommended to use the following method, and this method is stable and free!

Using jacob to convert Excel to PDF (recommended) 1. Environment preparation

You need to make some preparations before using jacob. First of all, you need to download jacob's compressed package jacob.zip, the download address.

After decompression, you get the following content:

If you are a 64-bit system, use x64 dll,32-bit systems and x86 dll. Then we need to put the dll file in the bin directory of your jdk, as shown in the following figure:

In this way, the preparatory work will be done.

Next, introduce the required dependencies of Jacob in Maven:

Com.jacob jacob 1.19 system D:\ DevInstall\ jacob18,19\ jacob-1.19\ jacob.jar

Note: the value of the tag in the above dependency is the specific path of your jacob.jar, which can be changed to the corresponding path you just downloaded.

2. Execute the export PDF

The method to export PDF from Excel is as follows: the more important parts are annotated, and the method can be used directly!

/ * using jacob to transfer excel to PDF * * @ param inputFilePath Import Excel File path * @ param outputFilePath Export PDF File path * / public static void jacobExcelToPDF (String inputFilePath, String outputFilePath) {ActiveXComponent ax = null; Dispatch excel = null; try {ComThread.InitSTA (); ax = new ActiveXComponent ("Excel.Application") Ax.setProperty ("Visible", new Variant (false)); / / disable macro ax.setProperty ("AutomationSecurity", new Variant (3)); Dispatch excels = ax.getProperty ("Workbooks") .toDispatch () Object [] obj = {inputFilePath, new Variant (false), new Variant (false)}; excel = Dispatch.invoke (excels, "Open", Dispatch.Method, obj, new int [9]). ToDispatch () / / conversion format Object [] obj2 = {/ / PDF format equals 0 new Variant (0), outputFilePath, / 0 = standard (the resulting PDF image will not be blurred) 1 = smallest file new Variant (0)} Dispatch.invoke (excel, "ExportAsFixedFormat", Dispatch.Method, obj2, new int [1]);} catch (Exception e) {e.printStackTrace (); throw e;} finally {if (excel! = null) {Dispatch.call (excel, "Close", new Variant (false)) } if (ax! = null) {ax.invoke ("Quit", new Variant [] {}); ax = null;} ComThread.Release () }} Thank you for your reading, the above is the content of "what are the methods for Java to achieve Excel to PDF". After the study of this article, I believe you have a deeper understanding of what the method of Java to Excel to PDF has, and the specific use still needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.