Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

error while inserting data using poi

 
vijayz devraj
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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..
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!