Traceback (most recent call last):
File "create_and_update_xlsx_sheets.py", line 183, in <module>
create_and_update_worksheets()
File "create_and_update_xlsx_sheets.py", line 178, in create_and_update_worksheets
resize_columns(sheet)
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/pandas/io/excel.py", line 786, in __exit__
self.close()
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/pandas/io/excel.py", line 790, in close
return self.save()
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/pandas/io/excel.py", line 824, in save
return self.book.save(self.path)
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/openpyxl/workbook/workbook.py", line 345, in save
save_workbook(self, filename)
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/openpyxl/writer/excel.py", line 266, in save_workbook
writer.save(filename)
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/openpyxl/writer/excel.py", line 248, in save
self.write_data()
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/openpyxl/writer/excel.py", line 93, in write_data
archive.writestr(ARC_WORKBOOK, write_workbook(self.workbook))
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/openpyxl/writer/workbook.py", line 91, in write_workbook
active = get_active_sheet(wb)
File "/home/Dave/.virtualenvs/NHL/lib/python3.5/site-packages/openpyxl/writer/workbook.py", line 61, in get_active_sheet
raise IndexError("At least one sheet must be visible")
IndexError: At least one sheet must be visible
我对这种错误很熟悉。我从某个网站获取CSV数据,但是订阅过期了,所以我得到了这个错误。我想记录一个具体的错误,它会告诉我'至少有一个工作表必须是可见的。验证您的订阅blabla.com网站仍然是活跃的。“每当我有这种错误。我怎么能用python做这种事呢
使用
try
和except
。在如果您不知道logger是如何工作的,请查看this tutorial by Fang。如果您想了解Python中的异常,请查看jornsharpe在注释中给出的tutorial。在
相关问题 更多 >
编程相关推荐