Category "apache-poi"

Apache POI : delete the cached results from the file

I am trying to update an existing Excel file with many formulas. I can't use evaluate-function ( Excel-file contains a function not supported by Apache POI )

Store cell values to Object

I'm currently new to TestNG using java. I'm trying to read the values from an excel using poi apache 4.0 public static void read2dRowExcelFile2(String filePath)

Java Apache POI Excel save as PDF

How can I convert/save excel file to pdf? I'm using java play framework to generate some excel files and now the requirement changes to pdf. I don't want to rec

How to append to existing excel file using Java HSSF

I am still relatively new to Java and have cobbled together enough code that allows me to write my data out to a new excel file. However, I want it to write (a

Apache POI: Is it possible to use SXSSF without temporary files?

I'd like to use SXSSF (Streaming Usermodel API) from Apache POI. What I don't like is that it uses temporary files. Question: Is it possible in Apache POI to f

Not able to set custom color in XSSFCell Apache POI

I am trying to set some custom(from hexcode or rgb value) color to a xssfcell.But the color of the cell is becoming black even though I am giving some other col

Dynamically creating rows in Excel sheet with Apache POI

I'm writing a program to read a large xml file and create an excel file from it. The attributes of each node will be the column headers in excel file. I created

POI - ZIP entry size is too large

I use JXLS to create my woorkbook. JXLS uses POI underneath. To create a workbook JXLS either need a File or an input stream. With file object I get my desired

How to list all embedded files from a microsoft office document, using Apache POI?

is there any opportunity to list all embedded objects (doc, ..., txt) in a office file (doc, docx, xls, xlsx, ppt, pptx, ...)? I am using Apache POI (Java) Li