Don't skip blank lines in pandas.read_excel()

Question

According to multiple sources on SO (1, 2, 3), the pandas method read_excel() has the option skip_blank_lines to control whether pandas parses blank rows in an excel file as blank rows in a DataFrame. However, the current documentation does not mention this. Has it been deprecated? If so, when, and, most importantly, how can I replicate the effect of skip_blank_lines=False without it?

Answer 1

This method has not been deprecated as of the latest release, and I don't know of any intentions to deprecate it (0.24.1 does not produce a future warning when using this method).

As to why it's not documented on the read_excel page, I believe it's because skip_blank_lines=False is passed as a keyword argument to TextFileReader (which is hinted at in the documentation).