Top "Apache-poi" questions

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

Apache POI Locking Header Rows

Is anyone out there familiar with a way to lock a row in a spreadsheet created with Apache POI 3.7? By …

java apache-poi
Convert csv to xls/xlsx using Apache poi?

I need to convert csv to xls/xlsx in my project? How can i do that? Can anyone post me …

spring spring-mvc apache-poi xssf poi-hssf
Multiline text in Excel cells

I'm trying to write multiline text to excel cells. cell.setCellValue("line1 \n line2"); But when I open the document, …

java excel apache-poi export-to-excel
API to write huge excel files using java

I am looking to write to an excel (.xls MS Excel 2003 format) file programatically using Java. The excel output files …

java excel apache-poi
java.lang.NoClassDefFoundError: Could not initialize class org.apache.poi.POIXMLDocument on Jboss 5.0 EAP

Getting following exception in Jboss 5.0 EAP but it work fine in JBoss 5.1 GA. we are using POI 3.7 and jars included …

java apache-poi jboss5.x jsf-1.2
Display percentage values in Excel using POI API

I need to display a value in an excel cell formatted like a percentage, e.g. like 12.3%. By default the …

java excel apache-poi
Reading string value from Excel with HSSF but it's double

I'm using HSSF-POI for reading excel data. The problem is I have values in a cell that look like a …

java excel apache-poi poi-hssf
How to use rowiterator in apache poi with java?

I tried to read an excel file using apache poi in java, however, Eclipse did not compile the code. public …

java row apache-poi hssf
Create a password protected Excel file using Apache POI?

I am developing a simple Java program to create an Excel file using (Apache POI) API. I am using Oracle 10…

java excel apache-poi xls
java.lang.ClassNotFoundException: org.apache.poi.xssf.usermodel.XSSFWorkbook

when i tried to create a workbook in normal java class it is creating but when i tried to run …

java servlets apache-poi xlsx xssf