Python learning notes (processing date format in excel) and python learning notes

Python learning notes (processing date format in excel) and python learning notes

Processing date format data in excel files

Sort it out here

The code for the two methods is as follows:

1 def get_time (cls, table, nrows): 2 testtime = [] 3 for I in range (1, nrows): 4 data1 = xlrd. xldate. xldate_as_datetime (table. cell (I, 6 ). value, 1) 5 # convert the date format to the datetime object 6 data2 = xlrd. xldate_as_tuple (table. cell (I, 6 ). value, 0) 7 # convert the date format to the metagroup 8 testtime. append (data2. _ str _ () 9 # convert tuples to strings 10 print data1, data2, testtime