Limit on number of rows exported to Microsoft Excel from Spotfire

Product: Spotfire Analyst
Versions:All

Summary:
When exporting data to Microsoft Excel the following message may be displayed "The selected output has a limitation of 1048576 rows and only the first 1048576 rows of the selected data will be exported".

Details:
When exporting data from Spotfire to an Excel spreadsheet, the following message is displayed when there are more than 1,048,576 rows in the Spotfire data table (when exporting to an .xlsx file - if using .xls the limit is 65,536 rows)

Text of message:
Export Data
The selected output has a limitation of 1048576 rows and only the first 1048576 rows of the selected data will be exported.

Resolution:
This is due to a Microsoft limitation on Excel spreadsheets and there is no way for Spotfire to avoid this. The most you can export to Excel is 1,048,576 rows by 16,384 columns. See Excel specifications and limits for more details.  

If you require an export to Microsoft Excel from Spotfire, ensure your data has fewer than 1,048,576 rows and fewer than 16,384 columns in Spotfire before exporting.

Note: this row limit only exists for exports to the Excel file formats - there is no such limit for the other available export formats, such as .csv or .txt files.