Question
3
Replies
902
Views
Tech Mahindra Ltd
Posted: 2 years ago
Last activity: 2 years 9 months ago
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.
Posted: 2 years ago
Posted: 2 years ago
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: 2 years ago
There might be a resource conflict, try setting the automation at This to asynch.
How are you trying to do this?