我在使用python读取Excel文件后成功读取了单元格的数据,但是出现了一个问题,就是在题干、选项中可能会出现数字(包括了整形数据、浮点型数据),但当我读取这些数据的时候,python不论是整形或浮点型数据都转换成了浮点型,该还原它的本来面目呢?
```python
import xlrd
def read_excel():
workbook = xlrd.open_workbook('table/infos.xls', encoding_override='utf-8')
# 操作Excel
sheet = workbook.sheet_by_index(0)
rows = sheet.nrows # 得到有多少行5
tests = []
for i in range(1, rows):
d = sheet.row(i)
stem = str(d[1]).split(":")[1].replace("'", "") # 获取题干
optiona = str(d[2]).split(":")[1].replace("'", "") # 选项A,可能是文字,整数、小数
optionb = str(d[3]).split(":")[1].replace("'", "") # 选项B,可能是文字,整数、小数
optionc = str(d[4]).split(":")[1].replace("'", "") # 选项C,可能是文字,整数、小数
optiond = str(d[5]).split(":")[1].replace("'", "") # 选项D,可能是文字,整数、小数
type = str(d[6]).split(":")[1].replace("'", "") # 题型
diff = str(d[7]).split(":")[1].replace("'", "") # 难度
analysis = str(d[8]).split(":")[1].replace("'", "") # 解析
answer = str(d[9]).split(":")[1].replace("'", "") # 答案
t_dict = {"stem": stem, "optiona": optiona, "optionb": optionb, "optionc": optionc, "optiond": optiond,
"type": type, "diff": diff, "analysis": analysis, "answer": answer}#封装
tests.append(t_dict)
return tests
if __name__ == '__main__':
res = read_excel()
print(res)
```