• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

need help regarding POI workbook ?

 
naved momin
Ranch Hand
Posts: 692
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ben Ooms
Ranch Hand
Posts: 47
Debian Eclipse IDE Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:


regards,
Ben
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic