import xlrd
book = xlrd.open_workbook('electrical.xlsx')
sheet = book.sheet_by_index(0)
data = []
for row in range(0, sheet.nrows):
l = []
for column in range(0, sheet.ncols):
val = sheet.cell(row, column).value
if isinstance(val,float):
l.append(int(val))
else:
l.append(val)
data.append(l)
print(data) # [['Meter ID', 'value'], ['id101', '1'], ['id102', '2'], ['id103', '3']]
假设我有如下所示的excel数据 electrical.xlsx
我可以编写代码来检查是否存在任何浮点数据类型。如果存在,则转换为字符串
相关问题 更多 >
编程相关推荐