Error[Read Range: Extension 'zip' is not supported. Supported extensions are '.xlsx', '.xlsm', '.xltx' and '.xltm'.]

[RPA_Innovation]

Hi all,
I’m migrating my uipath projects from another laptop. I have unzipped the file but when I run the robot it show [Read Range: Extension ‘zip’ is not supported. Supported extensions are ‘.xlsx’, ‘.xlsm’, ‘.xltx’ and ‘.xltm’.]
Any idea to fix it? thanks:))
Below are my attachments to show the error:

[Gokul001 (Gokul Balaji)]

HI @RPA_Innovation

You can’t able to Read the .zip extension file in Read Range activity.

You should read only the Excel file in that activity.

[Gokul001 (Gokul Balaji)]

Hi @RPA_Innovation

Before reading the excel file You need to Unzip the folder.

For Unzip check out this thread

Unzip Files using invoke method

I’m opening your workflow and I get this warning 'ZipFile' does not have a public static method named 'ExtractToDirectory' matching the parameter types, generic type arguments, and generic type constraints supplied to InvokeMethod. Basically you’re trying to call ZipFile.ExtracttoDirectory() instead of ZipFile.ExtractToDirectory(zipFile, extractPath) After setting the parameters (zipPath, extractPath) for the ExtractToDirectory method it will work. Aren’t you getting the same? [image]

After that you can Use read Range activity to Read the excel file.

Regards
Gokul

[RPA_Innovation]

I actually unzipped the file before I run the .xaml file, do I still need to use the unzip files activity?

[Gokul001 (Gokul Balaji)]

Hi @RPA_Innovation

In the filename you have the Zip extension, so you are facing the error. Check out the Screenshot

[RPA_Innovation]

I see, so in order to modify the filename in local, the only way is to use unzip activity in uipath studio?

[william.coulson (Will Coulson)]

Hi @RPA_Innovation,

If you’re unzipping the file you need to update filename to the filepath of the unzipped file. You can try unzipping the file and then doing this in an assign:

filename = System.IO.Directory.GetFiles(YourFilepath)(0)

I recently developed a similar function:

[Gokul001 (Gokul Balaji)]

Yes @RPA_Innovation unzip the folder and use excel file.