def loadXls(curPath, fileName): data = dF.readXls(curPath+fileName) table = data.sheets()[0] # 打开第一张表 nrows = table.nrows # 获取表的行数 ncols = table.ncols dataList = [] for row in range(nrows): # 循环逐行打印 tmpList = [] if row ==0: pass else: for col in range(ncols): if col==3 or col==4: date = xldate_as_tuple(table.cell(row, col).value, 0) value = datetime.datetime(*date) value = value.strftime("%Y-%m-%d") tmpList.append(value) else: tmpList.append(table.cell(row, col).value) # dataList.append(tmpList) return dataList
转换excel中时间字段的格式
最新推荐文章于 2021-07-20 18:03:52 发布