Save as multiple csv files into xlsx

Help StudioX
,
1

I have multiple CSV files in multiple folders, for which we just need to open each csv file and do F12 and save as xlsx. and overwrite the same file and do this in a loop for all csv files in all folders. There is no formatting or editing required for csv files only simple save as in xlsx format is needed. Can someone please advise on how to create workflow in StudioX?

2

HI,

It’s unnecessary to use F12. Can you try the following sample? This saves csv files as xlsx under src folder.

image
image1240×1033 31.7 KB

Sample
NewBlankTask20240626-1.zip (51.4 KB)

Regards,

1 Like
3

@pooja.desai
check the thread

4

Hi @Yoichi,
thank you for the solution and i tried however there is issue while saving the excel file as it is asking for the sensitivity label as below. It would be great if you can help on this as well.

image
image1092×452 22.7 KB

5

Thank you @Krishna_Raj for your response.

6

Hi,

Can you try to add UIAutoamtion logic for it OR try the following sample without Excel?

image
image917×771 23.7 KB

Sample
NewBlankTask20240626-1v2.zip (51.3 KB)

Regards,

7

Thank you @Yoichi for your guidance on the workflow.
The sample file is working however i have to manually select the sensitivity label for each csv file getting save as xlsx file.

The workflow mentioned to read csv is having below error as the file is not a csv file where editing or formatting is required, its just the saving required in xlsx format without any edits
image

8

Can you try to add Click activity etc for automation in UseExcelFile?

The workflow mentioned to read csv is having below error

This error can be avoided by using ReadTextFile and GenerateDataTable instead of ReadCSV, as the following.

image
image1266×946 28.9 KB

Sample
NewBlankTask20240626-1v3.zip (55.2 KB)

Regards,

9

Appreciate your help!! Can you please review the workflow for click activity and guide me where i need to place the click or make any changes?

image
image421×681 28.9 KB

image
image348×686 26 KB

10

The Encodian API can has a ConvertExcel action and can handle many cross format conversion types including CSV to XLSX.

Swagger UI (apps-encodian.com)

see /api/v1/Core/ConvertExcel

The support pages has documentation for the Encodian PowerAutomate connector but the pages will show you the options and how each action works:

Power Automate Action Documentation – Encodian Customer Help

Specifically:

Convert Excel – Encodian Customer Help