How to get date in dd/mm/yy format from a timestamp in excel using python [duplicate]

Question

I am reading data from a excel sheet like this -

day1 = first_sheet.cell(row,26).value

I want to use this date for some other operations later but the data is coming in a float format which i find very confusing and unsuitable for debugging.

I tried using this --->>

day = datetime.datetime(*xlrd.xldate_as_tuple(day1, 0))

But i got this error --->>

AttributeError: type object 'datetime.datetime' has no attribute 'datetime'

I am using python 2.7 Kindly help me out.

Will you please go through this stackoverflow.com/questions/12906402/… — Arundas R
– Arundas R, Commented Mar 2, 2015 at 13:28

Ankit Sachdeva · Accepted Answer · 2015-03-02 13:59:40Z

0

You can try this.

day1 = first_sheet.cell(row,26).value
d = xlrd.xldate_as_tuple(int(day1), 0)
#convert date tuple in yy-mm-dd format
d = datetime.datetime(*(d[0:3]))
dStr = d.strftime('%Y-%m-%d')

answered Mar 2, 2015 at 13:59

Ankit Sachdeva

1791 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get date in dd/mm/yy format from a timestamp in excel using python [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related