File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes need help regarding POI workbook ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "need help regarding POI workbook ?" Watch "need help regarding POI workbook ?" New topic

need help regarding POI workbook ?

naved momin
Ranch Hand

Joined: Jul 03, 2011
Posts: 692

can any one help please i have an requirement where i need to import data from the sql and make a excel report of that
i m using POI workbook , but it is creating a problem for me
the problem is that
when i create a new cell the old cell value disappears from the excel document
i m putting the code , hope any one can find out whats wrong in my code

please help me guyz i need to complete this project by sunday
if you know any other free open source project that might help me writing excel documents than that will be awfull.

The Only way to learn is!
Visit my blog
Ben Ooms
Ranch Hand

Joined: May 16, 2011
Posts: 44

I don't know if this is related to your problem but I see that you use the same row twice:

at line 174:
and at line 198:

This means that after writing your columnnames at row 9 when you write the data rows row 9 is overwriten. I think the code at line 198 should be:

I agree. Here's the link:
subject: need help regarding POI workbook ?
It's not a secret anymore!