Insert Rows & Columns into Excel in Python

VB C#

from ironxl import *

# Load existing spreadsheet
workbook = WorkBook.Load("sample.xlsx")
worksheet = workbook.DefaultWorkSheet

# Add a row before row 1
worksheet.InsertRow(0)

# Insert multiple rows before row 4
worksheet.InsertRows(3, 3)

# Add a column before column A
worksheet.InsertColumn(0)

# Insert multiple columns before column F
worksheet.InsertColumns(5, 2)

# Save changes with added rows and columns
workbook.SaveAs("addRowAndColumn.xlsx")

Insert Rows & Columns into Excel in Python

IronXL for Python provides the ability to insert individual or multiple rows and columns programmatically, without requiring Office Interop.

Insert Row

The InsertRow and InsertRows methods add new rows to the worksheet. Rows are inserted before the specified index position.

Insert Column

Use the InsertColumn and InsertColumns methods to add one or more columns before the specified index position.

All index positions use zero-based indexing.

Learn How to Add Rows and Columns in Excel with Python

Ready to Get Started?

Version: 2026.4 just released

Still Scrolling?

Want proof fast?
run a sample watch your data become a spreadsheet.

Try IronXL for Free

Get Set Up in 5 Minutes

Licenses from $749

Iron Support Team

We're online 24 hours, 5 days a week.

Chat

Email

Call Me