def multiple_dfs(sheet, row=2):
writer = pd.ExcelWriter("testing.xlsx", engine='openpyxl')
f1 = {
'user': ['Bob', 'Jane', 'Alice'],
'income': [40000, 50000, 42000],
}
f2 = {
'amount': ['Chest', 'Bras', 'Braa'],
'income': [40000, 50000, 42000]
}
frames = [f1, f2]
for f in frames:
try:
wb = load_workbook("testing.xlsx")
ws = wb.get_sheet_by_name("aaa")
writer.wb = wb
writer.sheets = dict((ws.title, ws) for ws in wb.worksheets)
row = ws.max_row + 2
except:
pass
df = pd.DataFrame(f)
df.to_excel(writer, sheet, startrow=row, index=False)
writer.save()
# writer.close()
multiple_dfs('aaa')我犯了这个错误,但我不能改正。我调整了代码中正在发生的事情的简短表示,但很难看出真正的问题在哪里。这是
Traceback (most recent call last):
File "create_and_update_xlsx_sheets.py", line 144, in <module>
create_and_update_worksheets()
File "create_and_update_xlsx_sheets.py", line 140, in create_and_update_worksheets
writer.save()
File "/home/jeremie/.virtualenvs/NHL/lib/python3.5/site-packages/pandas/io/excel.py", line 824, in save
return self.book.save(self.path)
...
File "/home/jeremie/.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我怎么才能解决这个问题?
P.S.要注意错误被显示的时间是一半。
发布于 2022-02-23 22:39:42
同样的错误,IndexError: At least one sheet must be visible,在创建一个作者时一致地复制,然后保存,而没有编写任何东西。示例:
writer = pd.ExcelWriter(file_name, engine='openpyxl')
writer.save()在编写代码时,尽管在调用save之前有工作表,工作簿在编写时并不包含任何可见的或其他的工作表。
当然,很难将其与您的代码相匹配,但对于您或next dev来说,可能会遇到相同的错误。
https://stackoverflow.com/questions/46840960
复制相似问题