记录特定消息

Question

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做这种事呢

Answer 1

使用try和except。在

try:
  # code that produces the error. ex:
  active = get_active_sheet(wb) # or
  raise IndexError("At least one sheet should be visible")
except IndexError as err:
  logger.error("An error occurred whilst pulling CSV from %s. Please ensure your connection to %s is still active.", website)

如果您不知道logger是如何工作的，请查看this tutorial by Fang。如果您想了解Python中的异常，请查看jornsharpe在注释中给出的tutorial。在