notebooks-ai / notebooks-help

Issues with Notebooks.ai? Create an issue here!
https://notebooks.ai
MIT License
14 stars 5 forks source link

TyperError executing writer.save() in Notebooks-AI Tutorial #37

Open sccx opened 4 years ago

sccx commented 4 years ago

I'm working through the Notebooks-AI tutorial in a Chrome browser on a Macbook Air, running OS X Catalina 10.15.1. Upon executing the final line of the tutorial, the following error occurred:


TypeError Traceback (most recent call last)

in ----> 1 writer.save() /usr/local/lib/python3.7/site-packages/pandas/io/excel/_openpyxl.py in save(self) 42 Save workbook to disk. 43 """ ---> 44 return self.book.save(self.path) 45 46 @classmethod /usr/local/lib/python3.7/site-packages/openpyxl/workbook/workbook.py in save(self, filename) 406 if self.write_only and not self.worksheets: 407 self.create_sheet() --> 408 save_workbook(self, filename) 409 410 /usr/local/lib/python3.7/site-packages/openpyxl/writer/excel.py in save_workbook(workbook, filename) 291 archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True) 292 writer = ExcelWriter(workbook, archive) --> 293 writer.save() 294 return True 295 /usr/local/lib/python3.7/site-packages/openpyxl/writer/excel.py in save(self) 273 def save(self): 274 """Write data into the archive.""" --> 275 self.write_data() 276 self._archive.close() 277 /usr/local/lib/python3.7/site-packages/openpyxl/writer/excel.py in write_data(self) 73 archive.writestr(ARC_THEME, theme_xml) 74 ---> 75 self._write_worksheets() 76 self._write_chartsheets() 77 self._write_images() /usr/local/lib/python3.7/site-packages/openpyxl/writer/excel.py in _write_worksheets(self) 213 214 ws._id = idx --> 215 self.write_worksheet(ws) 216 217 if ws._drawing: /usr/local/lib/python3.7/site-packages/openpyxl/writer/excel.py in write_worksheet(self, ws) 198 else: 199 writer = WorksheetWriter(ws) --> 200 writer.write() 201 202 ws._rels = writer._rels /usr/local/lib/python3.7/site-packages/openpyxl/worksheet/_writer.py in write(self) 352 High level 353 """ --> 354 self.write_top() 355 self.write_rows() 356 self.write_tail() /usr/local/lib/python3.7/site-packages/openpyxl/worksheet/_writer.py in write_top(self) 96 cols 97 """ ---> 98 self.write_properties() 99 self.write_dimensions() 100 self.write_views() /usr/local/lib/python3.7/site-packages/openpyxl/worksheet/_writer.py in write_properties(self) 58 def write_properties(self): 59 props = self.ws.sheet_properties ---> 60 self.xf.send(props.to_tree()) 61 62 /usr/local/lib/python3.7/site-packages/openpyxl/worksheet/_writer.py in get_stream(self) 292 continue 293 else: --> 294 xf.write(el) 295 except GeneratorExit: 296 pass src/lxml/serializer.pxi in lxml.etree._IncrementalFileWriter.write() TypeError: got invalid input value of type , expected string or Element