I have an excel sheet which has 30 rows in which i add more rows using ApachePOI. Now my
Java program gets the last row number, increase it by one and adds data for that row.
When i go to the excel sheet after adding an row, its added perfectly. But when i delete that row from excel sheet, again add an row using the program, the row is added below the
row which i deleted i.e. it also considers the blank row as row.
Lets say i add 31st row to my excel sheet, delete it from the excel sheet and when i again run the program, the new row is added to 32nd row instead of 31st.
Any idea why this could be happening and how to resolve it?