wood burning stoves 2.0*
The moose likes JDBC and the fly likes error while inserting data using poi Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "error while inserting data using poi" Watch "error while inserting data using poi" New topic
Author

error while inserting data using poi

vijayz devraj
Greenhorn

Joined: Apr 03, 2008
Posts: 7
hi to all

iam working on jdbc iam using poi (HSSF ) excel sheet to insert data.
whenver iam inserting 10 rows of data, the data is entered without error but again when iam inserting only 2 rows of data using same sheet iam getting error.

the error i found is, its reading all the previously entered physical data of 10 rows.. that is it is expecting there are 10 rows but there is only 2 rows.

ia there any way to clear the physical data of the sheet. so that when i use again the sheet the previously inserted(physical data) no of rows should be cleared..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: error while inserting data using poi