Microsoft Excel Web Query File

[KetanNagariya]

Hi Team,

I am facing a problem while reading the data from Microsoft Excel Web Query File. Below is the scenario :

Scenario - I am downloading a file from a SharePoint which is downloaded in the form of excel web query file (.iqy) and trying to read that file using Excel VBO actions but not able to read that file properly instead Blueprism is becoming unresponsive  when getting data into collection.

Kindly suggest me if we have any other options to read and write excel web query file (.iqy) into the collection of Blueprism.

Thanks in advance.

Ketan Nagaiya
[email protected]

------------------------------
Ketan Nagariya
RPA Developer

------------------------------

[dmma]

Hi,
How big is file you trying to access/open and how many rows do you have there?

------------------------------
Kind regards,

Dmitrij Mamajev
RPA Developer
Volvo Cars
Gothenburg - Sweden
------------------------------

[KetanNagariya]

Hi,

The file contains nearly 250 rows and 16 columns.

Thanks,
Ketan Nagariya

------------------------------
Ketan Nagariya
Consultant
ADP
Europe/London
------------------------------

[RaviMalhotra]

Hi ketan, 

Hope you are doing good.  I am facing same problem as i have one web query file and need to convert to excel spread sheet.
Can you please help in letting me know,  how you fix this issue. 

Thanks
Ravi Malhotra


------------------------------
Ravi Malhotra
------------------------------