Add back skip_blank_lines to read_excel in pandas v>1.1.4

[jankaWIS]

Is your feature request related to a problem?

Reading Stack Overflow, there has been several posts trying to skip blank lines when reading (post 1, post 2, post 3, ...). The proposed solution works for pandas v<0.24 but there is no mention about this feature and trying to use it I get:
In pandas 1.1.4 and 1.2: TypeError: read_excel() got an unexpected keyword argument 'skip_blank_lines' and no mention in the documentation posted above.

Describe the solution you'd like

Pandas read_excel and/or ExcelFile should get back this argument and functionality

[lithomas1]

@jankaWIS Thanks for the bug report! I think this is due to #34464, which dropped support for *kwds that were passed to TextFileReader(skip_blank_lines being one of them). Labeling as regression for now.
cc @topper-123 @WillAyd

The fix for this would actually be very simple if the core devs wished to add this back(Adding *kwds here

pandas/pandas/io/excel/_base.py

Line 373 in fc9fdba

mangle_dupe_cols=mangle_dupe_cols,

and

pandas/pandas/io/excel/_base.py

Line 336 in fc9fdba

storage_options: StorageOptions = None,

[WillAyd]

We don’t need to add back in the keyword arguments - can just add this parameter to read_excel and document

[lithomas1]

If anyone wants to take this up, the fix would be to add skip_blank_lines to the read_excel signature and to the io.parse call. Do note that you'll also need to add back the docstring(see variable _read_excel_doc) in file pandas/io/excel/_base.py.

[ahawryluk]

take