Invalid row number (65536) outside allowable range (0..65535)

Hi,
I am trying to load a data table to excel. but I am getting the error “Invalid row number (65536) outside allowable range (0…65535)”. The number of rows in data table is around 66K.

Can anybody suggest my how to fix the issue?

Thanks,
Sarayu

Hii @sarayu cross check the number of rows count in datatable because excel can handle rows upto 65536 only

@sarayu

Welcome to the UIPath Community.

What activity are you using to load dataTable into excel ? Are you using Write Range activity or not ?

Hi Kalyan, I checked it’s around 66K records. Is there anyway I can fix this?

Thanks,
Sarayu

Hi Lakshman,
yes we are using WriteRange activity to load from data table to excel.

Thanks,
Sarayu

1 Like

@sarayu

It should work. If possible could you please share that excel and xaml file. Will check and update you.

Hi @sarayu In excel you can insert rows only 65536 you can’t exceed this number if you want you also check in excel open any excel you can only see rows up to 65536 only and there is no any there options because excel supports rows to inset only 65536 lines.

If you are trying to insert rows more than 65536 error will come definitely manually also you cant exceed this number.

Sorry it’s not allowing me to upload the file as I am a new user.

HI @sarayu

Welcome to UiPath community budd

I think this error usually occurs because of the Excel version compatibility issue
may i know what version of excel is been used
For more info on this error and kindly follow the steps mentioned @sarayu

Cheers @sarayu

were you able to load the data now buddy @sarayu

Excel can handle more than 65536 rows now. This limitation was tied to Excel 2003 if I recall correctly.

Hello Palaniyappan,
yes the excel was “.xls” file and I changed that to “.xlsx” and rerunning the process.

Thanks,
Sarayu

aah may be that could be a problem too
use as it is buddy with .xls file as it will accepted by read range or write range activity in excel activities
Cheers @sarayu

.xls is the format used by Excel 2003 and before so it will not be able to handle more than 65536 rows. .xlsx is used by later versions, and allows you to have more rows. Changing the extension works because it changes the file to a version that Excel knows can handle more rows.

Thank you all for your quick response :grinning:

1 Like