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,
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
Thank you for the response. But, how can I read the .iqy file? Do you have any sample template that I can use?
Regards,
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
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
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
Yes, this is similar but could you share the sample xaml for this ?
Thanks…
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
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!
Hi,
Do you try to use Excel Application Scope ?
you can put the path to your excel file.
Hi,
It doesn’t support other than .xlsx and .xls file format. Any other solutions pls?
Thanks!
is there any other ways to do that?
Was there any solution found for this?I tried the above mentioned methods, but it is not working
