Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

REGR: ExcelWriter fails when supplying kwargs #42286

Closed
rhshadrach opened this issue Jun 28, 2021 · 0 comments · Fixed by #42292
Closed

REGR: ExcelWriter fails when supplying kwargs #42286

rhshadrach opened this issue Jun 28, 2021 · 0 comments · Fixed by #42292
Assignees
Labels
IO Excel read_excel, to_excel Regression Functionality that used to work in a prior pandas version
Milestone

Comments

@rhshadrach
Copy link
Member

with pd.ExcelWriter('asdf.xlsx', engine='xlsxwriter', options={'nan_inf_to_errors': True}) as writer:
    pass

gives

scratch.py:38: FutureWarning: Use of **kwargs is deprecated, use engine_kwargs instead.
  with pd.ExcelWriter('asdf.xlsx', engine='xlsxwriter', options={'nan_inf_to_errors': True}) as writer:
Traceback (most recent call last):
  File "scratch.py", line 38, in <module>
    with pd.ExcelWriter('asdf.xlsx', engine='xlsxwriter', options={'nan_inf_to_errors': True}) as writer:
TypeError: __init__() got an unexpected keyword argument 'options'

#40430 deprecated the use of kwargs and is the most likely culprit, but need to confirm.

@rhshadrach rhshadrach added Regression Functionality that used to work in a prior pandas version IO Excel read_excel, to_excel labels Jun 28, 2021
@rhshadrach rhshadrach added this to the 1.3 milestone Jun 28, 2021
@rhshadrach rhshadrach self-assigned this Jun 28, 2021
This was referenced Jun 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
IO Excel read_excel, to_excel Regression Functionality that used to work in a prior pandas version
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant