Limit on number of rows exported to Microsoft Excel from Spotfire
Article ID: KB0070991
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All |
| TIBCO Cloud Spotfire | All |
Description
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.
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.
Issue/Introduction
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".
Environment
All
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.
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.
Additional Information
External: Excel specifications and limits
Feedback
Yes
No
Powered by
