Sep-03-2019, 05:40 PM
I was actually able to insert the new column using
import pandas as pd from pandas import ExcelWriter from pandas import ExcelFile df = pd.read_excel('C:/Users/u678153/Desktop/FIN_-_Find_Customer_Invoices_Lines_with_Worktags.xlsx', sheet_name='Detail', skiprows=12) df.insert(15, 'CON/PLAN', '') df.to_csv('C:/Users/u678153/Desktop/test.csv')