Read CSV Error - Missing Method

Hi,

I’m facing this error regarding the activity Read CSV:

Could someone help me? I already tried to reinstall both Excel and CSV Packages and it didn’t work. Besides that, I can’t think about any “plan B” to do the same function.

Thanks in forward.

1 Like

Hi @guisposito1,

Can you provide the xaml file?

2 Likes

Hi Hareesh,

Sorry, but I can’t. It contains some of my client information, therefore I cannot do this.

Which kind of information would help you to help me?

Thanks!

1 Like

It’s okay,

Can I have the screenshots of the activities you are using for opening the CSV files.

2 Likes

Actually, I already understood what happened.

The file is being extracted with the Excel layout but with the CSV format (.csv). That’s why the activity “Read CSV” is not working, the file layout isn’t compatible. My need now is to just change the format to Excel (.xlsx). There is no need to read the file.

Do you know any activity that I could just change its format?

1 Like

Actual process to convert CSV to excel is reading the CSV and storing in a data table and writing the same to the excel sheet

But i don’t have any idea how to convert directly. If you do the same process using FTP, there may be a chance of file corruption.

2 Likes