Failed opening the Excel file

[sarathi125 (Parthasarathi)]

Hi All,

I am getting the below mentioned error while reading a excel file using Excel Application Scope.

Excel Application Scope Read Input Excel : Failed opening the Excel file D:\Projects\Input.xlsx. Possible reasons: the file is corrupt, the file is already used by another process or you don’t have permissions to open the file.

I have killed the excel process before reading the excel with the current session. Even after that I am getting this error.

[NIVED_NAMBIAR (NIVED N)]

Check the package version of excel activitiy @sarathi125 and reinstalled it again

[anandji05 (ANAND PRIYA TRIPATHI)]

@sarathi125

Can you share the xlsx file? If you have not sensitive data.

Regards
Anand

[Kavyasri (Kavya)]

Hi, Make sure that you closed the excel file while you are running it and also check the path you mentioned is correct or not.

Happy Automation.

[Srini84 (Srinivas)]

@sarathi125

You can use the Workbook activities as the excel file is .xlsx

For reference on Workbook activities check below

Tutorial : How to Calculate difference between two Time Values using UiPath

Hello @Srini84! It seems that you have trouble getting an answer to your question in the first 24 hours. Let us give you a few hints and helpful links. First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic. You can check out some of our resources directly, see below: Always search first. It is the best way to quickly find your answer. Check out the [image] icon for that. Clicking the options button will let you set mo…

Hope this may helps you

Thanks

[sarathi125 (Parthasarathi)]

I cannot share the file as it has sensitive data

[sarathi125 (Parthasarathi)]

Checked the version of excel activities package it is 20.8.6 version.

[sarathi125 (Parthasarathi)]

@Srini84,

As a best practice we should use Excel Application Scope, not the Workbook activities, where it will not handle huge file in size.

[sarathi125 (Parthasarathi)]

@Kavyasri,

Yes, I have coded that, but have to check that in PROD environment.

[Srini84 (Srinivas)]

@sarathi125

If you have a huge file then you can do excel as Database

May be the one reason to fail opening the excel file is of huge entries also

Check below post for Excel as Database

Read Huge Excel - Getting error

@saransrs Instead of using Read Range activities or Excel application scope, You can use Excel as database, and execute queries Check below post Mark as solution if this helps you Thanks

Hope this helps you

Thanks

[sarathi125 (Parthasarathi)]

@Srini84,

My customer is not ready to install the AccessDatabaseEngine.
So I am looking for someother work around.

[JayakumarSanthanam (Jayakumar)]

Hi,

1. For checking if size is issue, kindly split the data to smaller portions
2. For checking if that excel is corrupt, kindly copy the data to entirely new excel
3. To check if folder is accessible check a blank excel in same folder and open it in the work flow.

Thanks

[LADISZAN (Ladislav Zán)]

HINT

I spent many hours on this… Now I know, that Excel application scope is not compatible with background job. Please, check if you have Starts in Background selected as No.

If you have xlsx filetype, then use System/File/Workbook/ activities, not App Integration/Excel/ activities if you wan to have background job.

Hopefully this helps.