Good day,
My script prints to an Excel file. When I run it on a folder it's fine but when I run it on the entire database I get the error message: Cannot print because out range (0, 67556).
NB: Note that I initialized the RowCounter as: var numberRows - 0
How to declare a numeric value as Double (vs Integer)?
Thank you
Samuel
Hi Samuel,
The Rows cannot be increased beyond excel limit, one change you can do is changing your extension of your output file to XLSX where it allows you to create upto 1048575 rows.
var out = Context.createExcelWorkbook("<FileName>.xlsx");
For Excel Limits:https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
Good day,
Thank you Robert and Jeya.
What I have done is to re-direct the output Excel to the server the script is running from.
The script ran fine and created 3 Excel sheets.
Thank you
Samuel
.
Robert Goldenbaum on
Hi,
well the maximal number of rows is defined by Excel and cannot be changed. You just have to open up a new sheet/tab and write there.
Or you use the new excel with the xlsx ending - there should be no max number there anymore (but I have not tried it).
BR Robert