To read .iqy file in Uipath

Build
,
#1

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,

#2

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

1 Like
#3

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

Regards,

#4

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

image
image.png1310×249 16.7 KB

Regards,
Susana

#5

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

#6

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

#7

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

Thanks…

#8

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

image
image.png746×544 43.3 KB

after this click on refresh all --> connection properties

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

image
image.png416×608 27.6 KB

Thanks,
Meg

#9

Hi,

I am looking for the same exact requirement. How to read .iqy file as Data table/how to convert .iqy file into .xlsx. Hope you help me if you have got a solution.

Thanks!