From version 5 EPPlus can insert and delete rows, columns and ranges in a worksheet. Formulas/references in the workbook affected by the change will be adjusted, EPPlus does this for formulas, styles, ...

To delete a row or column, right click the row or column header and select Delete. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction requires permission.

In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data, especially if there is not enough space within the columns ...