Oct-24-2017, 01:42 PM
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)