aspose file tools*
The moose likes Other JSE/JEE APIs and the fly likes problem in appending new row in excel sheet using POI API 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 » Java » Other JSE/JEE APIs
Bookmark "problem in appending new row in excel sheet using POI API" Watch "problem in appending new row in excel sheet using POI API" New topic
Author

problem in appending new row in excel sheet using POI API

swapnel surade
Ranch Hand

Joined: Mar 05, 2009
Posts: 129
Hello,

I'm using POI API to read the .xls file, but when I want to append new line in the file there is no method in api to append at the end of file.
I found HSSFSheet.createRow(int rownum) method but it requires the line number to insert, for that i have to traverse the excel sheet to get the last line number.
Is there any better option to append new row to end of the file ?
swapnel surade
Ranch Hand

Joined: Mar 05, 2009
Posts: 129
using getRowNum() method can get the row count
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in appending new row in excel sheet using POI API