Feature Type

• Adding new functionality to pandas

• Changing existing functionality in pandas

• Removing existing functionality in pandas

Problem Description

Hello,

Excel has a formula for N/A: =na(). If is shown as #N/A.

Why not using this as default value for na_rep instead of ''?

So: df.to_excel('foobar.xlsx', na_rep='=na()')

Thanks a lot,
Michaël

Feature Description

def df.to_excel(..., na_rep='=na()', ...)

Alternative Solutions

N/A

Additional Context

No response