Learn about robust error reporting in Python in Excel!
By default, the xl() method in #pythoninexcel will convert Excel error values to NaN values in your DataFrame.
If you don't want that to happen, and you want Python in Excel to alert you to Excel errors, here's how to change the default behavior of the xl() method to raise those errors and not return the DataFrame until they're fixed.
#excel #python #pythoninexcel #data #analytics