Hi all,
I am trying to read data from an excel file using "xlrd" functions. File contains many columns one of which is Date and time (in MM/DD/YYYY and HH:MM:SS AM/PM format). I am successful in reading all other type of data. But unfortunately for this column, program could read only junk values. Please help me in this regard. Here is the snippet of my code.

readxl = xlrd.open_workbook('C:\Users\sourabh\Desktop\CallStatus.xls')
print readxl
print readxl.sheet_names()
sh1 = readxl.sheet_by_name('Sheet6')
print sh1
for rownum in range(sh1.nrows):
    print sh1.row_values(rownum)
cmn = sh1.col_values(10)
print cmn

thanks
Himanshu