Closed
Description
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.