How to enable excel with blue prism to get data as collection

[parwinder27]

Hi,
I need help to make a excel enable with blue prism before extracting data from excel. Is there any way to solve this problem?

 

[gil.silva]

Hello parwinder27,

Can you be more clear?
In order to extract data from excel to a collection you just need to use these 4 actions:
1) Create Handle
2) Open Excel
3) Get Worksheet as Collection
4) Close Instance

Hope it helps

 

[ranga]

Create instance
Open excel
Show workbook
Get worksheet as collection
Close workbook
Close instance
Follow these steps your problem will be resolved

Let me know any further assistance