Merging Cells in Excel Using POI

Merging Cells in Excel using POI can be done using the XSSFSheet.addMergedRegion(CellRangeAddress region) method. CellRangeAddress is the range of the rows and columns that need to be selected. In our case to be m

Read More →

Read Word Docx File Using POI

To read word docx file using POI we use the XWPFWordExtractor class. This class comes from the package org.apache.poi.xwpf.extractor and has a method getText() that returns all the content of the f

Read More →

Add Table to Word Doc using POI

In many cases we need to deal with tables in the Word Document. Apache POI makes it simple to add table to the Word Document. Lets see the way to add table to word doc using POI. Classes / Interfac

Read More →

Add Paragraph to Word Doc Using POI

In the last post we saw how to Create Word Doc file in Java Using POI. Now in this post we will see how to add Paragraph to Word doc using POI. Classes / Interfaces Used XWPFDocument [crayon-61eb22

Read More →

Fill Color in Excel using Apache POI

In some previous posts we have seen how we can create excel and also add various fonts to the excel file using Apache POI. Now we will see how to Fill Color in Excel using Apache POI. For giving a

Read More →

Borders in Excel using Apache POI

In some previous posts we have seen how we can create excel and also add various fonts to the excel file using Apache POI. Now we will see how to add borders in excel using Apache POI. Simple Borde

Read More →