BUG: parsing excel returns one row short
- [x ] I have checked that this issue has not already been reported.

- [x ] I have confirmed this bug exists on the latest version of pandas.

- [x ] (optional) I have confirmed this bug exists on the master branch of pandas.

---

**Note**: Please read [this guide](https://matthewrocklin.com/blog/work/2018/02/28/minimal-bug-reports) detailing how to provide the necessary information for us to reproduce your bug.

#### Code Sample, a copy-pastable example

```python
# Your code here

df = pd.read_excel("D:/Docs/Joop/Elektronica/uC/Raspberry Pi/Excel/PythonTest.xls")
# PythonTest.xls contains one column 4 rows on first sheet, rest empty
shape = df.shape    
print(shape)

#### Problem description
Parsing excel returns one row short 

#### Expected Output
(4, 1)

#### Output of ``pd.show_versions()``

<details>

INSTALLED VERSIONS
------------------
commit           : 2cb96529396d93b46abab7bbc73a208e708c642e
python           : 3.9.4.final.0
python-bits      : 64
OS               : Windows
OS-release       : 10
Version          : 10.0.19041
machine          : AMD64
processor        : Intel64 Family 6 Model 60 Stepping 3, GenuineIntel
byteorder        : little
LC_ALL           : None
LANG             : None
LOCALE           : Dutch_Netherlands.1252

pandas           : 1.2.4
numpy            : 1.20.2
pytz             : 2021.1
dateutil         : 2.8.1
pip              : 21.1.1
setuptools       : 49.2.1
Cython           : None
pytest           : None
hypothesis       : None
sphinx           : None
blosc            : None
feather          : None
xlsxwriter       : None
lxml.etree       : None
html5lib         : None
pymysql          : None
psycopg2         : None
jinja2           : None
IPython          : None
pandas_datareader: None
bs4              : None
bottleneck       : None
fsspec           : None
fastparquet      : None
gcsfs            : None
matplotlib       : None
numexpr          : None
odfpy            : None
openpyxl         : None
pandas_gbq       : None
pyarrow          : None
pyxlsb           : None
s3fs             : None
scipy            : None
sqlalchemy       : None
tables           : None
tabulate         : None
xarray           : None
xlrd             : 2.0.1
xlwt             : None
numba            : None

</details>

[PythonTest.xls](https://github.com/pandas-dev/pandas/files/6430145/PythonTest.xls)

Python Debug PDB:

<details>

> d:\docs\programs\python\python39\lib\site-packages\pandas\io\excel\_xlrd.py(112)get_sheet_data()
-> return data
(Pdb) data
[[1], [2], [3], [4]]
...
(Pdb) n
> d:\docs\programs\python\python39\lib\site-packages\pandas\io\excel\_base.py(540)parse()
-> has_index_names = is_list_like(header) and len(header) > 1
(Pdb) data
[[1], [2], [3], [4]]
(Pdb) c
> d:\docs\programs\python\python39\lib\site-packages\pandas\io\parsers.py(2231)TextParser()
-> kwds["engine"] = "python"
(Pdb) c
> d:\docs\programs\python\python39\lib\site-packages\pandas\io\parsers.py(2468)read()
-> try:
(Pdb) r
--Return--
> d:\docs\programs\python\python39\lib\site-packages\pandas\io\parsers.py(2509)read()->(None, [1], {1: array([2, 3, 4], dtype=int64)})
-> return index, columns, data
(Pdb) data
{1: array([2, 3, 4], dtype=int64)}
(Pdb) r
--Return--
> d:\docs\programs\python\python39\lib\site-packages\pandas\io\parsers.py(1077)read()->   1
0  2
1  3
2  4
-> return df
(Pdb) df
   1
0  2
1  3
2  4
(Pdb) c
(3, 1)

</details>
