Display embedded files on the document (.docx)

Hi, Is Apache poi capable of embedding other files in word documents (.docx)? I've managed to write an embed file but I can't display it (reference it) via an icon or a link inside the document. I use XWPFDocument and OPCPackage and I'm using Apache POI 3.11. This is my code : http://stackoverf

Unable to understand how to merge cells in POI

I'm writing a program where I need to merge rows in Excel sheet. Currently, I'm able to merge the starting rows, but when coming to the end, I'm unable to know where it is going wrong. Below is my code. import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import ja

Unable to understand how to merge Rows in POI

Hi, I'm writing a program where I need to merge rows in Excel sheet. Currently, I'm able to merge the starting rows, but when coming to the end, I'm unable to know where it is going wrong. Below is my code. import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; impo

How to access pivot table of very large excel using apache poi in java?

Hi, I am trying to get data source of pivot table using apache poi . But the excel file is very large and the code below gives out of memory issue : FileInputStream fis = new FileInputStream(new File("demo.xlsx")); XSSFWorkbook workbook = new XSSFWorkbook(fis); I tried using Sax parser as below :

RE: Unable to understand how to merge Rows in POI

You are not calling the merge method after your for loop when finalIndex > 0. Immediately following the for loop you need to add: If (finalIndex > 0) { sendRangeToMergeCells(startIndex, finalIndex, sheet); } -Original Message- From: sunnykeerthi [mailto:sunnykeer...@gmail.com] Sent:

RE: Unable to understand how to merge Rows in POI

Thanks Sir , this worked -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Unable-to-understand-how-to-merge-Rows-in-POI-tp5723107p5723119.html Sent from the POI - User mailing list archive at Nabble.com. -

confusion with merge using POI

I'm writing a program in POI to merge cells and I'm able to merge them. there is a column with number content, and when I merge this column and when I open my sheet and select this column to my surprise this shows the count and sum as if it is not merged. Below is my Excel.

Add complex footer to docx incrementing the page number

I need a footer with 3 parts: the current date on the left, a field value (in this case the opportunity #) in the center and the page number on the right preceded by the word "Page ". I am able to create this footer with the following code without an incremented page number: CTSec