Unable to read .iqy file using Excel Read Range

Help StudioX
,
1

Hi Team,

When i try to read a .iqy file using excel application scope - read range, I am getting below error. Excel package - 2.11.4(lowest applicable)

image

2

@Deeipauk

Welcome back to our UiPath community.

Is it working fine with previous Excel package versions ?

3

Hi

Welcome back to uipath forum

I think excel application scope activity will work on .iqy filetype

As the error shows the file is being used by someone make sure the file is closed and then give a try or use kill process activity and pass ProcessName as “Excel” and then use excel application scope

Also check whether you have the permission to open the file

Cheers @Deeipauk

1 Like
4

@Deeipauk,

Try to open the file manually first and then check if all the permission are given to the user to open the file.

Also please close the excel file when you are reading it.

5

Thanks…
I am using kill followed by delay and then trying to read, pls check this attachment.
Permission wise I can open this manually
image

6

So is it working or you are still facing the issue

@Deeipauk

7

Hi, it wa not working even after i added the delays so I have changed the approach of “Download to Excel” to “Download to CSV”. I think the .iqy file is having some security features added to it which is restricting UiPath to read the file.

Thanks for all the support and help provided here

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.