Insert column using openpyxl

python excel openpyxl
Shawn picture Shawn · Apr 5, 2013 · Viewed 20.1k times · Source

I'm working on a script that modifies an existing excel document and I need to have the ability to insert a column between two other columns like the VBA macro command .EntireColumn.Insert.

Is there any method with openpyxl to insert a column like this?
If not, any advice on writing one?

Answer

Naghmeh picture Naghmeh · Mar 22, 2018

Here is an example of a much much faster way:

    import openpyxl
    wb = openpyxl.load_workbook(filename)
    sheet = wb.worksheets[0]
    //this statement inserts a column before column 2
    sheet.insert_cols(2)
    wb.save("filename.xlsx")

Related questions

Pandas: Looking up the list of sheets in an excel file

The new version of Pandas uses the following interface to load Excel files: read_excel('path_to_file.xls', 'Sheet1', index_col=None, na_values=['NA']) but what if I don't know the sheets that are available? For example, …

Read More
getting sheet names from openpyxl

I have a moderately large xlsx file (around 14 MB) and OpenOffice hangs trying to open it. I was trying to use openpyxl to read the content, following this tutorial. The code snippet is as follows: from openpyxl import load_workbook …

Read More
how to write to a new cell in python using openpyxl

I wrote code which opens an excel file and iterates through each row and passes the value to another function. import openpyxl wb = load_workbook(filename='C:\Users\xxxxx') for ws in wb.worksheets: for row in ws.rows: print …

Read More