Two Laptop Bag*
The moose likes Other Open Source Projects and the fly likes APACHE POI Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "APACHE POI" Watch "APACHE POI" New topic
Author

APACHE POI

Hussain Mohd
Greenhorn

Joined: Apr 12, 2008
Posts: 1
hi

i am trying to read data from excel file using poi
but while reading a string value i used getStringCellValue() but this is depricated and in return i used HSSFRichTextString but iam facing an exception like no such methid error.

it was prompting as

org.apache.poi.hssf.usermodel.HSSFRichTextString
Note: This element neither has attached source nor attached Javadoc and hence no Javadoc could be found.

can anybody help me resolve this problem asap
[ April 12, 2008: Message edited by: Hussain Mohd ]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41052
    
  43
Welcome to JavaRanch.

It sounds as if there may be multiple versions of the POI jar file around - a newer one that is used for compiling, and an older one that is used at runtime. Make sure you're using the same (new) jar file everywhere.


Ping & DNS - my free Android networking tools app
Prashant Langade
Ranch Hand

Joined: Jul 01, 2009
Posts: 71
Hi

I am facing a strange issue in center alignment of text using poi in my project.

I am unable to set the text in center align mode. here is my code.
The code for setting text in center align mode is



Can any one help me?
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9915
    
158

Prashant Langade wrote:Hi

I am facing a strange issue in center alignment of text using poi in my project.


Prashant, please create a separate topic in the "Other Open Source Projects" forum, since your question doesn't relate to Tomcat.

[My Blog] [JavaRanch Journal]
haripriya kaligotla
Greenhorn

Joined: Jul 21, 2010
Posts: 3
Hi,
We are tryiing to write 60k rows and 100 cols to an excel sheet but getting the below exception:

"Exception in thread "main" java.lang.OutOfMemoryError: Java heap space"

Any help to get rid of this would be appreciated. Thanks.
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 9915
    
158

haripriya,

Welcome to JavaRanch.

Please create a separate topic with the relevant details, to discuss your issue.
 
 
subject: APACHE POI
 
Similar Threads
Java API for MS Excel 2010
Parsing Excel-2007-Format (xlsx)
add the j2ee javadoc to eclipse
Java code to merge 2 columns in a CSV file
How to convert XML to Excel Sheets