File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 JavaScript Promises Essentials this week in the JavaScript 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: 42592
    
  65
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: 10262
    
168

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: 10262
    
168

haripriya,

Welcome to JavaRanch.

Please create a separate topic with the relevant details, to discuss your issue.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: APACHE POI