Write Excel - Process failed
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
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
Find more posts tagged with
Sort by:
1 - 3 of
31
Altair EmployeeHi there,
are you writing to XLSX or XLS? Might be that this is the max for XLS?
Best,
Martin
Hi Martin,
It's unfortunately the same for both...
so i might have to reduce the output rows.
It's unfortunately the same for both...
so i might have to reduce the output rows.
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
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