What is maximum of rows can ARIS script print to Excel?

Posted by Samuel Adegbemle

Posted on Tue, 07/12/2016 - 19:45 in Reports & Macros

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

17.4k

by Robert Goldenbaum

Posted on Wed, 07/13/2016 - 08:40

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

by JeyaKarthik N R

Posted on Wed, 08/03/2016 - 09:28

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