Skip to main content
Contact a Moderator

Question

3
Replies
947
Views
 Pavan kumar (Pavank9210)
Tech Mahindra Ltd

Tech Mahindra Ltd
CA
Pavank9210 Member since 2017 6 posts
Tech Mahindra Ltd
Posted: December 13, 2017
Last activity: December 26, 2017
Posted: 13 Dec 2017 0:58 EST
Last activity: 26 Dec 2017 23:29 EST
Closed

Importing huge data to excel

When I am trying to Import data (13000) records to excel it taking more time with usual openspan automation, through OLEDB also it taking more time. is there any way to overcome this or any C# code available could you please share.

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 14 Dec 2017 1:37 EST
Pavan kumar (Pavank9210)
Tech Mahindra Ltd

Tech Mahindra Ltd
CA

Export the 13K data and convert to data table with automation, make some operations with data table then Import data to excel. Here while Importing it is teking more time.


Attached sample automation


 
Posted: 4 years ago
Posted: 26 Dec 2017 23:29 EST
Andrew Grondin (grona)
PEGA
GCS Solutions Engineer I
Pegasystems Inc.
US

There might be a resource conflict, try setting the automation at This to asynch.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice