[FIXED] How to open, delete columns and save a xls file in python

Issue

I need to know how to open a xls file that is already made, I want to delete some columns and then save the file. This is what I have but I get an error when I want to delete the columns. How do I use the DataFrame function to delete columns and then save.

Read in excel file

Workbook = xlrd.open_workbook("C:/Python/Python37/Files/firstCopy.xls", on_demand=True)
worksheet = Workbook.sheet_by_name("Sheet1")

Delete a column

df.DataFrame.drop(['StartDate', 'EndDate', 'EmployeeID'], axis=1, inplace=True)
Workbook.save('output.xls')

Solution

Here's what I would suggest:

import pandas as pd

df = pd.read_excel('firstCopy.xls')

df.drop(['StartDate', 'EndDate', 'EmployeeID'], axis=1)
writer = pd.ExcelWriter('output.xlsx')

df.to_excel(writer,'Sheet1')
writer.save()

Answered By - pizza lover