I have an instance where if a cell value is between 15 and 25 then I need to insert 10 blank rows, if the cell value is > 30 I need to insert 25 blank rows
Rather than simply typing the same syntax repeatedly and adding 1 row at a time, does EPPLUS have a function of adding X rows at one time?
This works but will be lots of code repeated:
ws.InsertRow(31, 31, 1);
The method you are using already takes care of that.
w.InsertRow(10, 15);
This will insert 15 rows starting at row 10. All the rows under will be shifted down.
The actual method signature:public void InsertRow(int rowFrom, int rows);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With