For the data in tabular form of your PDF and Word documents, you sometimes need to convert it to Excel spreadsheets. We need to automate this conversion of as many documents to spreadsheets or multiple workbooks. This article will discuss how to programmatically convert Word documents to Excel and also how to convert PDF files to Excel spreadsheets in Java.
The following topics are discussed briefly here:
- Java API - Documents to Spreadsheets Conversion
- Convert PDF to Excel Spreadsheet
- Convert Word to Excel Spreadsheet
- PDF or Word to Spreadsheet conversion with more options
Java API for Conversion to Spreadsheet
GroupDocs.Conversion for Java is the API that allows you to convert PDF and Word documents to spreadsheets within your Java applications. The API allows document and image conversions in many file formats. Some of the supported document formats include word-processing documents, spreadsheets, presentations, eBooks, AutoCAD formats, PDF, email messages, Web pages, images.
Download and Configure
You can get the conversion library from the downloads section or add the following pom.xml configuration in your Maven-based Java application. Afterward, you can try examples of this article as well as many more examples available on GitHub. For the details, you may visit the API Reference.
<repository> <id>GroupDocsJavaAPI</id> <name>GroupDocs Java API</name> <url>http://repository.groupdocs.com/repo/</url> </repository> <dependency> <groupId>com.groupdocs</groupId> <artifactId>groupdocs-conversion</artifactId> <version>21.4</version> </dependency>
Convert PDF to Excel in Java
The following steps can be followed to convert any PDF document to an Excel spreadsheet.
- Load the PDF file using Converter class.
- Prepare convert options using SpreadsheetConvertOptions.
- Call the convert method with the created options.
The following code sample shows how to convert a PDF file into an Excel XLSX spreadsheet in Java.
Convert Word to Excel in Java
Similarly, any Word document can be converted to an Excel spreadsheet in the same manner as we just converted the PDF document. Provide the right source file and get it converted into XLS or XLSX.
The following are the step to convert any DOC DOCX file to an Excel spreadsheet.
- Load the DOC, DOCX file using Converter class.
- Prepare the convert options using SpreadsheetConvertOptions.
- Call the convert method of the Converter class with options.
The following source code shows how to convert a DOC or DOCX file into Excel XLSX format in Java.
PDF or Word to Spreadsheet Conversion with more options using Java
You are not bound to get the whole document converted every time. You can convert just the selected pages of your document. The API gives you the privilege to convert the document with various options that include:
- Starting Page Number.
- Page Count.
- Specific Pages for conversion.
- Format to convert into.
- Password for make the file protected.
- Zoom to make it large or smaller.
- Watermark on the converter file.
The following are the steps for how to convert some of the pages of a PDF file into XLSX format with different zoom in Java.
The PDF file and the converted spreadsheet as output are shown here. It converted the second page of the PDF file into XLSX format.
Get a Free API License
You can get a free temporary license in order to use the API without evaluation limitations.
In this article, we discussed the conversion of PDF and Word documents to an Excel spreadsheet in Java. Additionally, we learned how to convert any part of the document with options like watermark, zoom, and make it protected using password protection.