Skip to content

REGR: ExcelWriter fails when supplying kwargs #42286

Closed
@rhshadrach

Description

@rhshadrach
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.

Metadata

Metadata

Assignees

Labels

IO Excelread_excel, to_excelRegressionFunctionality that used to work in a prior pandas version

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions