0

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

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by superbhimanshu
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.