IntelliJ Java IDE
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
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Reply 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: 124
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: 124
using getRowNum() method can get the row count
 
IntelliJ Java IDE
 
subject: problem in appending new row in excel sheet using POI API
 
Threads others viewed
Copy particular rows in excel using POI
generate large excel using zip stream
Reading an Excel File using Java
JExcel API clarifications
Unncessary empty spaces in excel file exported from websphere server
MyEclipse, The Clear Choice