为什么我的会报这些错,错误在上面,我写的代码在下边
来源:4-3 Excel写入数据
GEM意
2025-03-31 20:36:12
C:\Users\admin\AppData\Local\Programs\Python\Python37\python.exe C:\Users\admin\PycharmProjects\pythonProject3\4-3.py
Traceback (most recent call last):
File "C:\Users\admin\AppData\Local\Programs\Python\Python37\lib\site-packages\xlsxwriter\worksheet.py", line 551, in _write
f = float(token)
TypeError: float() argument must be a string or a number, not 'Cell'
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "C:\Users\admin\PycharmProjects\pythonProject3\4-3.py", line 35, in <module>
write(a)
File "C:\Users\admin\PycharmProjects\pythonProject3\4-3.py", line 31, in write
book.write(index,sub_index,sub_data)
File "C:\Users\admin\AppData\Local\Programs\Python\Python37\lib\site-packages\xlsxwriter\worksheet.py", line 108, in cell_wrapper
return method(self, *args, **kwargs)
File "C:\Users\admin\AppData\Local\Programs\Python\Python37\lib\site-packages\xlsxwriter\worksheet.py", line 481, in write
return self._write(row, col, *args)
File "C:\Users\admin\AppData\Local\Programs\Python\Python37\lib\site-packages\xlsxwriter\worksheet.py", line 556, in _write
raise TypeError(f"Unsupported type {type(token)} in write()")
TypeError: Unsupported type <class 'xlrd.sheet.Cell'> in write()
import xlsxwriter
import xlrd
def read():
result=[]
excel=xlrd.open_workbook("study.xlsx")
book=excel.sheet_by_name("学生手册")
for i in book.get_rows():
content=[]
for j in i:
content.append(j)
result.append(content)
return result
def write(content):
excel=xlsxwriter.Workbook("李文.xlsx")
book=excel.add_worksheet('信息')
for index,data in enumerate(content):
for sub_index,sub_data in enumerate(data):
book.write(index,sub_index,sub_data)
excel.close()
if __name__=="__main__":
a=read()
write(a)1回答
好帮手慕小猿
2025-04-01
同学,你好!在read()函数的for 循环中,我们获取每一行数据后,循环这一行的每个单元格,应该取单元格的值,也就是将j.value添加到content中,不是j单元格添加到content中。修改如下
祝学习愉快~
相似问题