Apache POI Word - Core Classes. This chapter takes you through the classes and methods of Apache POI for managing a Word document. This is a marker interface (interface do not contain any methods), that notifies that the implemented class can be able to create a word document. Step 1: Open Eclipse and configure Apache POI jar files – Download Apache Jars. Note: If you are using Maven Project then you could include the dependencies in the pom.xml. Must Read: How to create Maven Project. Step 2: Open Excel Sheet and create some test data. Here I have saved my excel sheet on my D Drive. Download JAR files for ojdbc8 jar With dependencies Documentation Source code. Poi-ooxml org.apache.poi jackson-databind com.fasterxml.jackson.core. The Apache POI team is pleased to announce the release of XMLBeans 3.1.0. Featured are a handful of bug fixes. The Apache POI project has unretired the XMLBeans codebase and is maintaining it as a sub-project, due to its importance in the poi-ooxml codebase. A summary of changes is available in the Release Notes. Apache POI Word - Core Classes. This chapter takes you through the classes and methods of Apache POI for managing a Word document. This is a marker interface (interface do not contain any methods), that notifies that the implemented class can be able to create a word document.

• Poi Ooxml Jar Download 1.5.2
• Poi Ooxml Schemas 3.17 Jar Download
• Poi-ooxml Jar Download Maven
• Poi-ooxml Jar Download
• Poi Ooxml 3.17 Jar Download
• Java

Step 3: Download and add the following jar files in the lib folder: commons-collections4-4.1.jar Click Here; poi-3.17.jar Click Here; poi-ooxml-3.17.jar Click Here; poi-ooxml-schemas-3.17.jar Click Here; xmlbeans-2.6.0.jar Click Here; Step 4: Set the Class Path. Dec 04, 2020 Step 1: Open Eclipse and configure Apache POI jar files – Download Apache Jars. Note: If you are using Maven Project then you could include the dependencies in the pom.xml. Must Read: How to create Maven Project. Step 2: Open Excel Sheet and create some test data. Here I have saved my excel sheet on my D Drive.

• Apache POI Word Tutorial

• Apache POI Word Useful Resources

• Selected Reading

Many a time, a software application is required to generate reference documents in Microsoft Word file format. Sometimes, an application is even expected to receive Word files as input data.

Any Java programmer who wants to produce MS-Office files as output must use a predefined and read-only API to do so.

What is Apache POI?

Apache POI is a popular API that allows programmers to create, modify, and display MS-Office files using Java programs. It is an open source library developed and distributed by Apache Software Foundation to design or modify MS-Office files using Java program. It contains classes and methods to decode the user input data or a file into MS-Office documents.

Components of Apache POI

Apache POI contains classes and methods to work on all OLE2 Compound documents of MS-Office. The list of components of this API is given below −

• POIFS (Poor Obfuscation Implementation File System) − This component is the basic factor of all other POI elements. It is used to read different files explicitly.

• HSSF (Horrible SpreadSheet Format) − It is used to read and write .xls format of MS-Excel files.

• XSSF (XML SpreadSheet Format) − It is used for .xlsx file format of MS-Excel.

• HPSF (Horrible Property Set Format) − It is used to extract property sets of the MS-Office files.

• HWPF (Horrible Word Processor Format) − It is used to read and write .doc extension files of MS-Word.

• XWPF (XML Word Processor Format) − It is used to read and write .docx extension files of MS-Word.

• HSLF (Horrible Slide Layout Format) − It is used to read, create, and edit PowerPoint presentations.

• HDGF (Horrible DiaGram Format) − It contains classes and methods for MS-Visio binary files.

• HPBF (Horrible PuBlisher Format) − It is used to read and write MS-Publisher files.

This tutorial guides you through the process of working on MS-Word files using Java. Therefore the discussion is confined to HWPF and XWPF components.

Note − OLDER VERSIONS OF POI SUPPORT BINARY FILE FORMATS SUCH AS DOC, XLS, PPT, ETC. VERSION 3.5 ONWARDS, POI SUPPORTS OOXML FILE FORMATS OF MS-OFFICE SUCH AS DOCX, XLSX, PPTX, ETC.

This chapter takes you through the process of setting up Apache POI on Windows and Linux based systems. Apache POI can be easily installed and integrated with your current Java environment, following a few simple steps without any complex setup procedures. User administration is required while installation.

System Requirements

Let us now proceed with the steps to install Apache POI.

Step 1: Verify your Java Installation

First of all, you need to have Java Software Development Kit (SDK) installed on your system. To verify this, execute any of the two commands mentioned below, depending on the platform you are working on.

If the Java installation has been done properly, then it will display the current version and specification of your Java installation. A sample output is given in the following table −

Poi Ooxml Jar Download 1.5.2

• We assume that the readers of this tutorial have Java SDK version 1.7.0_60 installed on their system.

• In case you do not have Java SDK, download its current version from https://www.oracle.com/technetwork/java/javase/downloads/index.html and have it installed.

Step 2: Set your Java Environment

Set the environment variable JAVA_HOME to point to the base directory location where Java is installed on your machine. For example,

Append the full path of Java compiler location to the System Path.

Execute the command java - version from the command prompt as explained above.

Step 3: Install Apache POI Library

Download the latest version of Apache POI from https://poi.apache.org/download.html and unzip its contents to a folder from where the required libraries can be linked to your Java program. Let us assume the files are collected in a folder on C drive.

The following images shows the directories and the file structure inside the downloaded folder −

Add the complete path of the five jars as highlighted in the above image to the CLASSPATH.

This chapter takes you through the classes and methods of Apache POI for managing a Word document.

Document

This is a marker interface (interface do not contain any methods), that notifies that the implemented class can be able to create a word document.

XWPFDocument

This is a class under org.apache.poi.xwpf.usermodel package. It is used to create MS-Word Document with .docx file format.

Class Methods

For the remaining methods of this class, refer the complete API document at −

Package org.apache.poi.openxml4j.opc.internal.

XWPFParagraph

This is a class under org.apache.poi.xwpf.usermodel package and is used to create paragraph in a word document. This instance is also used to add all types of elements into word document.

Class Methods

For the remaining methods of this class, refer the complete API document at −

XWPFRun

This is a class under org.apache.poi.xwpf.usermodel package and is used to add a region of text to the paragraph.

Class Methods

For the remaining methods of this class, refer the complete API document at −

XWPFStyle

This is a class under org.apache.poi.xwpf.usermodel package and is used to add different styles to the object elements in a word document.

Class Methods

For the remaining methods of this class, refer the complete API document at −

XWPFTable

This is a class under org.apache.poi.xwpf.usermodel package and is used to add table data into a word document.

Class Methods

For the remaining methods of this class, refer the complete API document at:POI API Documentation

XWPFWordExtractor

This is a class under org.apache.poi.xwpf.extractor package. It is a basic parser class used to extract the simple text from a Word document.

Class Methods

For the remaining methods of this class, refer the complete API document at:POI API Documentation

Here the term 'document' refers to a MS-Word file. After completion of this chapter, you will be able to create new documents and open existing documents using your Java program.

Create Blank Document

The following simple program is used to create a blank MS-Word document −

Save the above Java code as CreateDocument.java, and then compile and execute it from the command prompt as follows −

If your system environment is configured with the POI library, it will compile and execute to generate a blank Excel file named createdocument.docx in your current directory and display the following output in the command prompt −

In this chapter you will learn how to create a Paragraph and how to add it to a document using Java. Paragraph is a part of a page in a Word file.

After completing this chapter, you will be able to create a Paragraph and perform read operations on it.

Create a Paragraph

First of all, let us create a Paragraph using the referenced classes discussed in the earlier chapters. By following the previous chapter, create a Document first, and then we can create a Paragraph.

The following code snippet is used to create a spreadsheet −

Run on Paragraph

You can enter the text or any object element, using Run. Using Paragraph instance you can create run.

The following code snippet is used to create a Run.

Write into a Paragraph

Let us try entering some text into a document. Consider the below text data −

The following code is used to write the above data into a paragraph.

Save the above Java code as CreateParagraph.java, and then compile and run it from the command prompt as follows −

It will compile and execute to generate a Word file named createparagraph.docx in your current directory and you will get the following output in the command prompt −

Poi Ooxml Schemas 3.17 Jar Download

The createparagraph.docx file looks as follows.

In this chapter, you will learn how to apply border to a paragraph using Java programming.

Applying Border

The following code is used to apply Borders in a Document −

Save the above code in a file named ApplyingBorder.java, compile and execute it from the command prompt as follows −

If your system is configured with the POI library, then it will compile and execute to generate a Word document named applyingborder.docx in your current directory and display the following output −

The applyingborder.docx file looks as follows −

In this chapter, you will learn how to create a table of data in a document. You can create a table data by using XWPFTable class. By adding each Row to table and adding each cell to Row, you will get table data.

Create Table

The following code is used to creating table in a document −

Save the above code in a file named CreateTable.java. Compile and execute it from the command prompt as follows −

It generates a Word file named createtable.docx in your current directory and display the following output on the command prompt −

The createtable.docx file looks as follows −

This chapter shows how to apply different font styles and alignments in a Word document using Java. Generally, Font Style contains: Font size, Type, Bold, Italic, and Underline. And Alignment is categorized into left, center, right, and justify.

Font Style

The following code is used to set different styles of font −

Save the above code as FontStyle.java and then compile and execute it from the command prompt as follows −

It will generate a Word file named fontstyle.docx in your current directory and display the following output on the command prompt −

The fontstyle.docx file looks as follows.

Alignment

The following code is used to set alignment to the paragraph text −

Save the above code as AlignParagraph.java and then compile and execute it from the command prompt as follows −

It will generate a Word file named alignparagraph.docx in your current directory and display the following output in the command prompt −

Poi-ooxml Jar Download Maven

The alignparagraph.docx file looks as follows −

This chapter explains how to extract simple text data from a Word document using Java. In case you want to extract metadata from a Word document, make use of Apache Tika.

For .docx files, we use the class org.apache.poi.xwpf.extractor.XPFFWordExtractor that extracts and returns simple data from a Word file. In the same way, we have different methodologies to extract headings, footnotes, table data, etc. from a Word file.

The following code shows how to extract simple text from a Word file −

Save the above code as WordExtractor.java. Compile and execute it from the command prompt as follows −

It will generate the following output:

In this section, we are going to learn how we can read data from an excel file.

In Java, reading excel file is not similar to read word file because of cells in excel file. JDK does not provide direct API to read or write Microsoft Excel or Word document. We have to rely on the third-party library that is Apache POI.

What is Apache POI?

Apache POI (Poor Obfuscation Implementation) is a Java API for reading and writing Microsoft Documents in both formats .xls and .xlsx. It contains classes and interfaces. The Apache POI library provides two implementations for reading excel files:

• HSSF (Horrible SpreadSheet Format) Implementation: It denotes an API that is working with Excel 2003 or earlier versions.
• XSSF (XML SpreadSheet Format) Implementation: It denotes an API that is working with Excel 2007 or later versions.

Interfaces and Classes in Apache POI

Poi-ooxml Jar Download

Interfaces

• Workbook: It represents an Excel Workbook. It is an interface implement by HSSFWorkbook and XSSFWorkbook.
• Sheet: It is an interface that represents an Excel worksheet. A sheet is a central structure of a workbook, which represents a grid of cells. The Sheet interface extends java.lang.Iterable.
• Row: It is also an interface that represents the row of the spreadsheet. The Row interface extends java.lang.Iterable. There are two concrete classes: HSSFRow and XSSFRow.
• Cell: It is an interface. It is a high-level representation of a cell in a row of the spreadsheet. HSSFCell and XSSFCell implement Cell interface.

Classes

XLS Classes

• HSSFWorkbook: It is a class representing the XLS file.
• HSSFSheet: It is a class representing the sheet in an XLS file.
• HSSFRow: It is a class representing a row in the sheet of XLS file.
• HSSFCell: It is a class representing a cell in a row of XLS file.

XLSX Classes

• XSSFWorkbook: It is a class representing the XLSX file.
• XSSFSheet: It is a class representing the sheet in an XLSX file.
• XSSFRow: It is a class representing a row in the sheet of XLSX file.
• XSSFCell: It is a class representing a cell in a row of XLSX file.

Steps to read data from XLS file

Step 1: Create a simple Java project in eclipse.

Step 2: Now, create a lib folder in the project.

Poi Ooxml 3.17 Jar Download

Step 3: Download and add the following jar files in the lib folder:

• commons-collections4-4.1.jar Click Here
• poi-3.17.jar Click Here
• poi-ooxml-3.17.jar Click Here
• poi-ooxml-schemas-3.17.jar Click Here
• xmlbeans-2.6.0.jar Click Here

Step 4: Set the Class Path:

Right-click on the project ->Build Path ->Add External JARs -> select all the above jar files -> Apply and close.

Step 5: Now create a class file with the name ReadExcelFileDemo and write the following code in the file.

Step 6: Create an excel file with the name 'student.xls' and write some data into it.

Step 7: Save and run the program.

Example of reading excel file (.xls) file

Output:

Reading XLSX File

All steps will remain same except file format.

Table: employee.xslx

Example of read excel file (.xlsx)

In this example we use XSSFWorkbook class.

Output:

Reading a particular cell value from a excel file (.xlsx)

Table: EmployeeData.xlsx

Java

Example

In the following example, we read the value of the 2^nd row and the 2^nd column. The row and column counting start from 0. So the program returns 'Software Engineer.'

Output: