getdatasubsetdownloadlinkfromprocess - Export Excel from User Interface.

jegadeeswaran over 7 years ago

Could you please let me know whether we have any limitation on number of rows in Excel by using getdatasubsetdownloadlinkfromprocess. Can i able to export excel sheet with around 1 million records by batching Qery entity and using getdatasubsetdownloadlinkfromprocess. Used case is to export the Excel from UI Screen/Records with million record. Please advise on this.

Discussion posts and replies are publicly visible

0 nathan.schmitz
Certified Associate Developer
over 7 years ago

I'd wager that you'd run into a timeout trying to export that volume of data. Even without technical obstacles, your users probably won't be terribly happy waiting minutes for their excel export to complete. I'd suggest a batch process that runs overnight instead.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eliot Gerson
Appian Employee
over 7 years ago

It might also be worth noting that Excel itself has a hard limit of approximately 1 million rows: support.office.com/.../Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3

I'd be curious to know what the use case is for having so many rows, especially in a single spreadsheet.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rajivr
Certified Associate Developer
over 7 years ago

Even i had such a requirement of exporting 2lakh records in to an excel. But the appian fails in doing so. So i had to export in batches of 8,000 per sheet. Then the user collated the data manually from multiple exported sheets.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 laxmiharshithap1 over 7 years ago

For you reference, please scroll to the bottom and see information about this plugin: forum.appian.com/.../e-131988
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rajivr
Certified Associate Developer
over 7 years ago

forum.appian.com/.../e-263138..May help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel