Unable to open file file is corrupted

Help Studio
1

Unable to Open file

Trying to open excel file which is encrypted .

I get an error message saying “Unable to open file. Reasons : file is corrupted, already used by an other process or you’re not allowed to open it

2

HI,

What activity do you use? If ReadRangeWorkbook, can you try to use UseExcelFile and ReadRangeX?
Also, can you share information for the encryption? Is it excel feature or using other tool?

Regards,

3

Before executing the Excel-related activities, try using the KILL PROCESS activity. In the ProcessName property, set it to “Excel” to ensure any existing Excel processes are closed.

also make sure u provide the password in properties if its encrypted

1 Like
4

@Swati7 use excel process scope activity and check the property Read Only use read range inside this. This will ensure that even file is being used by another process your code will not break.

5

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