Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
error in exporting huge table data to excel
Community
›
Forums
›
Technology & Integration
error in exporting huge table data to excel
New Post
New Post
prashanth charl
Posted on 2015-09-16
prashanth charl
Rank: #1807
Posted on 2015-09-16
Hi,
There is table in SQL which consists of huge data around 2 million.When I am trying to export data to excel using recordListToExport(download),it is throwing an server error .Is there an efficient way to export huge data into excel or csv or even text file.
Thanks,
Prashanth
Carlos Rocha
Posted on 2015-09-16
Carlos Rocha
Rank: #138
Posted on 2015-09-16
Solution
Hi,
I just took a look at
office support
and I noticed that excel has a limit of
1,048,576 rows
. so if you need to export almost 2 milion rows excel is not an option for you.
why do you need to have such a file?
Best regards
Carlos Rocha
Solution
prashanth charl
Posted on 2015-09-17
prashanth charl
Rank: #1807
Posted on 2015-09-17
Solution
Carlos Rocha
wrote:
Hi,
I just took a look at
office support
and I noticed that excel has a limit of
1,048,576 rows
. so if you need to export almost 2 milion rows excel is not an option for you.
why do you need to have such a file?
Best regards
Carlos Rocha
Hi,
Is it possible to export huge table data into text file? If so,is there any inbuilt extension to do it?
Thanks,
Prashanth
Solution
Curt Raddatz
Posted on 2015-09-17
Curt Raddatz
Rank: #97
Posted on 2015-09-17
Solution
In the Forge do a search for CSV and you'll find a few components that should work.
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...