How to covert XLDate type in excel to text type in python

Asked Nov 12 '14 at 16:25

Active Nov 12 '14 at 19:12

Viewed 271 times

How can I convert XLDate type in excel to text type in python. I am using xlrd to read excel sheet. But ,for example ,a cell contains 14:00 will be read as 0.5833333333333334 by xlrd.

Edit1

I read cell using:

r=sheet1.cell(2,4).value

Edit2

Cell format in excel is hh:mm.

edited Nov 12 '14 at 19:12

asked Nov 12 '14 at 16:25

mrbf

1

At least related: http://stackoverflow.com/questions/1108428/how-do-i-read-a-date-in-excel-format-in-python – alecxe Nov 12 '14 at 16:28
`sheet1.cell(2,4).Text`? – Mr. Mascaro Nov 12 '14 at 18:12
No, It doesn't work because 'Cell' object has no attribute 'text'. – mrbf Nov 12 '14 at 18:52

How to covert XLDate type in excel to text type in python

0 Answers0