Export to Excel

rajivr

Certified Associate Developer

over 7 years ago

My issue is:
I want to export may be one to two lakh of records in to an excel at a time. But i am not able to achieve this because the tool is not able to do so. So i had gone for batching(8000 records per batch) in exporting the same. Any alternatives on this?

Thanks in advance.

Discussion posts and replies are publicly visible

Parents

0 aloks0189
Certified Lead Developer
over 7 years ago

First of all, I inserted more than 3 lakhs rows in a table using java in loop, once it's got over, I used SQL to Excel smart service by passing the query as select * from tableName , and when I started the process execution, I found within 3 to 4 second the flow got moved forward and at the next node I.e. User Input Task I configured to download the generated document, I found it was containing more than 3 lakhs four thousand rows.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aloks0189
Certified Lead Developer
over 7 years ago

First of all, I inserted more than 3 lakhs rows in a table using java in loop, once it's got over, I used SQL to Excel smart service by passing the query as select * from tableName , and when I started the process execution, I found within 3 to 4 second the flow got moved forward and at the next node I.e. User Input Task I configured to download the generated document, I found it was containing more than 3 lakhs four thousand rows.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data