Exception Message: Too many rows (65537)
Download as pdf :
Products:
Last Updated:
14-Feb-2023
Last Updated:
14-Feb-2023
Versions:
Article ID:
000100745
Article ID:
000100745
Primary Subject:
Problem Statement
I got an error that pointed me to a log file with the next or similar message, how can I fix it?
Exception Message: Too many rows (65537): The maximum number of rows supported by this file format is 65537
Solution
There is a maximum of 65536 rows for .xls excel files. Fortunately, .xlsx files can take up to 1,048,576 rows. Right-click Model Settings| Output Spreadsheet Extension| .xlsx
Keep in mind that this setting can be different for the same model but running in DR and AO.
Keywords
65537, max rows, .xls, xlsx, exception message