I need to do something similar, but I get an excel error when I try to insert the row.
I'm using <row r="">
For example using the screenshot @Genhan-Chen provided, if I add the row to position 19 or above(20, 21, 22 etc), it will work, but when I try to add row to anything below it, the excel file shows an error and there is no data. Doesn't matter what row, I can try to add row to position 4 or 5 for example which are empty, I still get the error, and excel file opens with no data in it.