How do we create desired no. of new rows in between existing two rows in excel with POI v3.6 api?

If there is no data between the rows, then all you need to do is to add the data between the rows by specifying the row numbers.

In case you want to add new rows in the existing data. In that case, you need to write your own custom logic using our XLS reader to move data to the next row before adding a new row.

Can you give me an example to move data to the next row if i want to add new rows in the existing data. Any help would be much appreciated.

Thank you,

Regards,

Kishore

You can start from the last row and move it to the desired row by iterating over each cell. After that second last row to the next desired location and so on.