Top "Apache-poi" questions

Apache POI is a Java library for reading and writing various Microsoft file formats, especially Office related ones.

Apache POI error loading XSSFWorkbook class

I'm trying to write a program that works with Excel docs, but the HSSF format is too small for my …

java apache apache-poi xssf
Add borders to cells in POI generated Excel File

I am using POI to generate an Excel File. I need to add borders to specific cells in the worksheet. …

java excel border apache-poi
Java POI : How to read Excel cell value and not the formula computing it?

I am using Apache POI API to getting values from an Excel file. Everything is working great except with cells …

java excel apache-poi notimplementedexception
org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException:

I'm using the following jar files: dom4j-1.6.1.jar poi-3.9-20121203.jar poi-ooxml-3.9-20121203.jar poi-ooxml-schemas-3.9-20121203.jar xmlbeans-2.3.0.jar …

java apache-poi
How to insert a row between two rows in an existing excel with HSSF (Apache POI)

Somehow I manage to create new rows between two rows in an existing excel file. The problem is, some of …

java excel apache-poi poi-hssf
Alternative to deprecated getCellType

I'm reading an excel-file (file extension xlsx) using org.apache.poi 3.15. This is my code: try (FileInputStream fileInputStream = new FileInputStream(…

java apache-poi
Apache POI XSSFColor from hex code

I want to set the foreground color of a cell to a given color in hex code. For example, when …

java apache-poi
How to get an Excel Blank Cell Value in Apache POI?

I have a huge excel file with tons of columns which looks like this :- Column1 Column2 Column3 Column4 Column5 …

java apache apache-poi
Merge and align center cell using apache poi

I want to export data to excel using Apache poi. Now the problem that I am facing is that I …

java excel apache-poi