Add remove row

[mikewii]

Some excel files open with wrong row count 1048576, having some function to remove row would be extremely useful to fix broken excel files

[aral-matrix]

Hi @mikewii - thank you for the suggestion. This is non-trivial in terms of row renumbering, but I will provide a patch that allows deletion (clearing) of rows without renumbering functionality - this way you can accomplish what you like, without OpenXLSX having to guarantee row renumbering.
Obviously, deleting a row that is referenced somewhere in a formula would change / affect that formula.

[aral-matrix]

And it's done (in development-aral branch): 9775495. Specifically for your use case I ensured that for a row number closer to rowCount() than to the first row in the OOXML, the row is searched backwards.

Will close this issue when functionality is merged into the master branch.

[aral-matrix]

merged the patch into master today