Write Excel - Process failed

Lars_vegas

Hi Folks,
Sorry for asking such a basic question:
I have tried to have my results displayed as an Excel via Turbo Prep and via the Write Excel Operator.
Both are giving me the same Errornote:
Invalid Row number(1048576) outside allowable range (0.. 1048575)

How can i change the allowable range or is there any other fix for this problem?

Thanks in advance

MartinLiebig

Hi there,

are you writing to XLSX or XLS? Might be that this is the max for XLS?

Best,

Martin

Lars_vegas

Hi Martin,
It's unfortunately the same for both...

so i might have to reduce the output rows.

Marco_Boeck

Hi,

That is the maximum number of rows allowed in Excel. See Excel specifications here: https://support.microsoft.com/en-gb/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

Regards,
Marco