Getting Data from Excel
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-06-18 04:09 PM
Hi ,
I have a query regarding getting the data from excel sheet. I have a huge amount of data in the excel when i take in the collection it takes a lot of time to process that data and sometimes even the system gets hanged.
So what could be the solution for this how can i improve the performance when i deal with huge amount of data in excel.
Thanks
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-06-18 05:38 PM
You can read the Excelsheet also with a OleDbConnection.
There is a VBO available for this.
See also this thread for more tips and tricks:
https://portal.blueprism.com/forums/technical-queries/faq-hints-tips/ol…
