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..