python向excel写入数据openpyxl_使用openpyxl将数据写入现有的Excel工作表

Traceback(most recent call last):File"G:\ALL\Urenverantwoording\Wekelijks\Genereer_weekstaten.py",line46,ininsert_xlsx(dest_filename,employer,week)File"G:\ALL\Urenverantwoording\Wekelijks\Genereer_weekstaten.py",line44,ininsert_xlsx

wb.save(dest)File"C:\Python34\lib\site-packages\openpyxl\workbook\workbook.py",line298,insave

save_workbook(self,filename)File"C:\Python34\lib\site-packages\openpyxl\writer\excel.py",line198,insave_workbook

writer.save(filename,as_template=as_template)File"C:\Python34\lib\site-packages\openpyxl\writer\excel.py",line181,insave

self.write_data(archive,as_template=as_template)File"C:\Python34\lib\site-packages\openpyxl\writer\excel.py",line87,inwrite_data

self._write_worksheets(archive)File"C:\Python34\lib\site-packages\openpyxl\writer\excel.py",line114,in_write_worksheets

write_worksheet(sheet,self.workbook.shared_strings,File"C:\Python34\lib\site-packages\openpyxl\writer\worksheet.py",line302,inwrite_worksheet

xf.write(comments)File"C:\Python34\lib\contextlib.py",line66,in__exit__

next(self.gen)File"C:\Python34\lib\site-packages\openpyxl\xml\xmlfile.py",line51,inelement

self._write_element(el)File"C:\Python34\lib\site-packages\openpyxl\xml\xmlfile.py",line78,in_write_element

xml=tostring(element)File"C:\Python34\lib\xml\etree\ElementTree.py",line1126,intostring

short_empty_elements=short_empty_elements)File"C:\Python34\lib\xml\etree\ElementTree.py",line778,inwrite

short_empty_elements=short_empty_elements)File"C:\Python34\lib\xml\etree\ElementTree.py",line943,in_serialize_xml

short_empty_elements=short_empty_elements)File"C:\Python34\lib\xml\etree\ElementTree.py",line943,in_serialize_xml

short_empty_elements=short_empty_elements)File"C:\Python34\lib\xml\etree\ElementTree.py",line935,in_serialize_xml

v=_escape_attrib(v)File"C:\Python34\lib\xml\etree\ElementTree.py",line1093,in_escape_attrib

_raise_serialization_error(text)File"C:\Python34\lib\xml\etree\ElementTree.py",line1059,in_raise_serialization_error"cannot serialize %r (type %s)"%(text,type(text).__name__)TypeError:cannot serialize3(type int)