To read .iqy file in Uipath

aajan27 · January 23, 2019, 4:15am

Hello,

I have a requirement where-in I can save only .iqy file from one of the website and then have to read the contents of the file. I tried converting .iqy to .xls or .xlsx file but doing so, it says the file is corrupted. Any help is highly appreciated.

Thanks,

neonova · January 23, 2019, 4:17am

You can read the .iqy file and pull the contents into a datatable and then write that datable as a new .xlsx file and continue your processing like a normal excel file

aajan27 · January 23, 2019, 3:20pm

Thank you for the response. But, how can I read the .iqy file? Do you have any sample template that I can use?

Regards,

Susana · January 23, 2019, 7:45pm

Hello @aajan27,

Hope this could help you.

You can read iqy files using excel or notepad. So for example you can use Read Text File activity or Open Application activity to open the file with the excel application

Regards,
Susana

aajan27 · January 23, 2019, 8:11pm

Hello Susana,
I tried to use Read text File activity and it is not working. Below is the String output that I’m getting which is not even related to the contents inside the file.

WEB
1

Selection=
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=
SharePointListView={5B0CA011-A8EB-4A1D-8451-5EA51D39E33A}
SharePointListName={055779D0-C385-407C-A247-99CAA38E7CFC}
RootFolder=

Regards,
Anand

megharajky · January 23, 2019, 8:32pm

Hello,

I have a similar requirement, We have to read the data from SharePoint so what I did was exported to excel from SharePoint, it have me iqy query file, I opened it in Excel and automatically the Excel gets connected through query, now everytime I open/rearrange Excel the Excel data gets updated according to the query and I can use the updated data.

Is it similar? Hope this helps a bit.

Thanks,
Meg

aajan27 · January 23, 2019, 9:13pm

Yes, this is similar but could you share the sample xaml for this ?

Thanks…

megharajky · January 24, 2019, 5:58am

Sorry, cant share the confidential data, its fetching from Sharepoint which requires credentials to fetch.

I can guide through to resolve this,

Goto new excel and in Data tab and click on connections
there add a new connection --> anvigate to JQY file

after this click on refresh all --> connection properties

there you can give credentials and the refresh rate for the excel.

Thanks,
Meg