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 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
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
Add Border to Paragraph in Word Using POI
We have already see the creation of Word file and adding Paragraph to it using Apache POI. Now we will see how to add Border to Paragraph in Word using POI. Classes / Interfaces Used XWPFDocument [
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-650d58
Create Word Doc file in Java Using POI
Apache POI is very useful for working on with the MS office files like Word, Excel etc. In the post we will how to create word doc file in java using POI. Setup for Apache POI [crayon-650d58e415776
Add Formula to Excel using Apache POI
Excel file are also used to perform various stats in which formula plays are very important role. So when youa re creating a excel file using the POI library and you want to add formula’s to
Writing various Date Formats in Excel using POI
Using Apache POI we can write dates in various formats in an excel cell using CellStyle. Lets see ways of writing various date formats in excel using POI. Lets follow the below steps 1. Create a wo
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
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