I'm working onn below code to extract data from excel using python

[kiran]

import xlrd
import pandas as pd
#import mysqldb
import datetime



ExcelFileName = "D:\Oracle_Oct 2 to 6.xlsx"
workbook = xlrd.open_workbook(ExcelFileName)
worksheet = workbook.sheet_by_name("Timecard Details")
num_rows = worksheet.nrows
num_cols = worksheet.ncols



for r in range(1,num_rows):
        ClientNo =worksheet.cell(r,9).value
        data =ClientNo.split('|')
        date = worksheet.cell(r, 6).value
        dt=xlrd.xldate_as_datetime(date, workbook.datemode)
        hours = worksheet.cell(r, 7).value

        if 'MAINTENANCE' in data[0]:
            values=(data[2], '|',hours,'|',dt, '|', data[1],'|',data[0])

            df = pd.DataFrame({'customer': [data[2]],'time':[hours],'Date':[dt],'Mainetance type':[data[1]],'Maintenance':[data[0]] })


            writer = pd.ExcelWriter("D:\Data.xlsx", engine='xlsxwriter')


            df.to_excel(writer, sheet_name=' MAINTENANCE ')

            writer.save()
            print(df)