Excel

Excel

1. Excel date read

	f = xlwt.Workbook()
	date_format = xlwt.XFStyle()
	date_format.num_format_str = 'yyyy-mm-dd hh:mm:ss'
	sheet1 = f.add_sheet('Lyon_pat_id', cell_overwrite_ok=True)
	sheet1.write(i, w_j, table1.cell(i, w_j).value, date_format)

https://xlsxwriter.readthedocs.io/working_with_dates_and_time.html
https://stackoverflow.com/questions/54377960/converting-time-format-string-to-float
https://blog.csdn.net/y1535766478/article/details/78128574
https://blog.csdn.net/orangleliu/article/details/38476881

2. Excel read
   https://www.cnblogs.com/think-and-do/p/6357915.html