topic RE: Microsoft Excel Web Query File in Product Forum

Microsoft Excel Web Query File

KetanNagariya — Wed, 18 Dec 2019 08:42:00 GMT

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
ketannagariya@gmail.com

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

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

RE: Microsoft Excel Web Query File

dmma — Wed, 18 Dec 2019 10:09:00 GMT

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
------------------------------

RE: Microsoft Excel Web Query File

KetanNagariya — Thu, 19 Dec 2019 05:48:00 GMT

Hi,

The file contains nearly 250 rows and 16 columns.

Thanks,
Ketan Nagariya

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

RE: Microsoft Excel Web Query File

RaviMalhotra — Sun, 13 Sep 2020 10:14:00 GMT

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
------------------------------