#7651·modin

BUG: 'nrows' parameter do not seem to be honoured in read_excel()

Author: deathstalkrCreated Aug 19, 2025Updated Sep 4, 2025
Labelsbug 🦗pandas concordance 🐼P2

Modin version checks

  • I have checked that this issue has not already been reported.

  • I have confirmed this bug exists on the latest released version of Modin.

  • I have confirmed this bug exists on the main branch of Modin. (In order to do this you can follow this guide.)

Reproducible Example

python
import modin.pandas as pd

#without nrows parameter
df = pd.read_excel('test.xlsx')
df.shape
# output: (55213, 2)

#with nrows parameter
df = pd.read_excel('test.xlsx', nrows=1000)
df.shape
# output: (55213, 2)
# Expected output: (1000, 2)

Issue Description

It looks like the 'nrows' parameter is not getting correctly passed to the engine. I have tried with Ray and Dask (couldn't get unidist working on my machine at the time, though I suspect it wouldn't change things). This, makes the engine read the whole spreadsheet even when I don't need to read the whole file.

Expected Behavior

When using the 'nrows' parameter for read_excel(), the engine should only read the specified number of rows as given in the parameter.

Error Logs

Installed Versions

INSTALLED VERSIONS

commit : 14680b350a46c607631ec1290676f594c9da715c python : 3.10.12 python-bits : 64 OS : Linux OS-release : 6.8.0-60-generic Version : #63~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue Apr 22 19:00:15 UTC 2 machine : x86_64 processor : x86_64 byteorder : little LC_ALL : None LANG : en_IN LOCALE : en_IN.ISO8859-1

Modin dependencies

modin : 0.34.1 ray : 2.48.0 dask : 2025.7.0 distributed : 2025.7.0

pandas dependencies

pandas : 2.2.3 numpy : 2.2.6 pytz : 2022.1 dateutil : 2.9.0.post0 pip : 22.0.2 Cython : 3.1.1 sphinx : None IPython : 8.37.0 adbc-driver-postgresql: None adbc-driver-sqlite : None bs4 : 4.13.4 blosc : None bottleneck : None dataframe-api-compat : None fastparquet : None fsspec : 2025.5.1 html5lib : None hypothesis : None gcsfs : None jinja2 : 3.1.6 lxml.etree : 5.4.0 matplotlib : 3.10.3 numba : None numexpr : None odfpy : None openpyxl : 3.1.5 pandas_gbq : None psycopg2 : 2.9.10 pymysql : 1.4.6 pyarrow : 21.0.0 pyreadstat : None pytest : 8.3.5 python-calamine : None pyxlsb : None s3fs : None scipy : 1.15.3 sqlalchemy : None tables : None tabulate : None xarray : None xlrd : None xlsxwriter : None zstandard : 0.23.0 tzdata : 2025.2 qtpy : None pyqt5 : None