No easy solution for saving a CSV file as an XLSX?

Help StudioX
1

Hi Team,

I need to save a CSV file as an xlsx file but when I use the rename file activity, my newly saved file wont open. What gives?

Please is there any easy solution? Keep in mind I am using StudioX, so the activities are different from Studio.

Thanks!

1 Like
2

Hi @jibroni,

If the file is not very large, you can read it and then print it again with the xlsx extension.

Regards,
MY

3

Hello @jibroni

You can refer to the below post. Also there are custom activities available to accomplish this.

4

Hi,

Hope the following sample helps you.

image

Sample20220521-3X.zip (49.6 KB)

Regards,

3 Likes
5

Hi

Have a view on this doc with a sample workflow

Hope this would help you resolve this issue

Cheers @jibroni

1 Like
6

Thanks everyone for the quick replies. I followed the tutorial shared by @Palaniyappan and here is what I set up and ran succesfully.

image
image502×653 40.6 KB

7

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