python表格格式输出_用python判断Excel单元格格式为输出日期（日期字段位置不固定）的，按datetime格式输出日期（而非float）...

目前的逻辑&＃xff1a;forsheetNameinwb.sheet_names():withopen(full_txt_name,mode&＃61;&＃39;a&＃39;)astxtFile:sheet&＃61;wb.sheet_by_name(sheetName)forrownuminrange(1,sheet.nrows):forcolnuminrange(0,s...

目前的逻辑&＃xff1a;

for sheetName in wb.sheet_names():

with open(full_txt_name, mode&＃61;&＃39;a&＃39;) as txtFile:

sheet &＃61; wb.sheet_by_name(sheetName)

for rownum in range(1,sheet.nrows):

for colnum in range(0,sheet.ncols):

v1 &＃61; sheet.cell(rownum, colnum).value

if (type(v1) &＃61;&＃61; float):

v1 &＃61; str(v1)

v1 &＃61; re.sub(&＃39;\.0*$&＃39;, "", v1)

txtFile.write(v1)

if colnum

txtFile.write(&＃39;|&＃39;)

else:

txtFile.write(&＃39;\n&＃39;)

txtFile.close()

效果&＃xff1a;

Excel表中某字段展现为2016-6-14 17:35:00

转为txt后为42535.7326388889

需要&＃xff0c;转为txt后为2016-6-14 17:35:00或20160614

虽然通过增加下列代码

from xlrd import xldate_as_tuple

from datetime import datetime

v1 &＃61; datetime(*xldate_as_tuple(v1,0))

能将浮点转成需要的日期&＃xff0c;但是对于非数值字段&＃xff0c;就会报错

invalid literal for int() with base 10:&＃39;anycharacter&＃39;

并且会误杀金额类float

不知道如何判断Excel格式&＃xff0c;请大神指点&＃xff0c;谢谢&＃xff01;

展开