Convert already encrypted excel files to csv

Help Activities
, , ,
1

Hi,
I tried to convert an excel sheet to csv but the file is already encrypted. I need to fetch password from another excel sheet and decrypt the excel file using the password. I tried cryptography activities for the same but it never worked for me. Is it the right method or is there any other method for the same?

2

Hi @Gopalakrishnan_K

If the excel file is encrypted, you had add the password in the read range property panel

after reading the excel , write the datatable to csv file using write csv file activity

Regards,
Nived N

3

Hi Nived,
I tried doing it but gives an error.

password
password1358×579 44.9 KB

Read Range: Specified method is not supported.
How to resolve it?

4

Can u restart ur workflow or try updating your excel packages @Gopalakrishnan_K

5

Hi,
Done it but no change.

6

@Gopalakrishnan_K

Let us know that encrypted means it is encrypted with AES mode kind of thing?

If so then you can use Decrypt File activity in Cryptography activities

Let us know the issue you are facing once you decrypt the file

Hope this may help you

Thanks

7

Hi,
Files are encrypted by uploading to the website Protect XLS Online for Free - Free Online Encrypt Excel with Password.