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

Help Studio
, , ,
1

Error : sheet_AN: Invalid row number (65536) outside allowable range (0…65535)

I want to copy from File 1 Column C (row 654) to file 2 and column AN . Starting cell would be AN4.
I am using simple read and write excel workbook but giving some error in write activity.

Please advice.

2

@Pal_Patel,

Are you using Workbook activities or Excel activities?

Thanks,
Ashok :slight_smile:

3

@Pal_Patel are you using .xls format? it has limitation of 65536 rows. You can use xlsx format it has more rows

Find Maximum Rows and Columns supported by XLS and XLSX formats|Documentation.

1 Like
4

Hi @muktadir You are right. I was using .xls to write and it was causing the issue. I changes it to .xlsx and it is working.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.