Insert New Rows & Columns

IronXL library allows the ability to insert single & multiple rows and columns in C# code without using Office Interop.

Insert Row

The InsertRow and InsertRows methods enable adding brand-new rows. Using these methods will add row(s) before the specified index position.

Insert Column

Use InsertColumn and InsertColumns methods to add column(s) before the specified index position.

Please note that all the index positions mentioned above follow zero-based indexing.