How to change csv file format to xlsx format

how to change csv file format to xlsx format in the same excel
how to make changes in the current excel file

@anjani_priya

CSV and excel as two different types

you can read the csv file using read csv and then use a write range activity to write the datatable to a new excel

Alternately you can use use excel file activity pass the csv as the input file

and then use save as excel file activity and select .xlsx

image

cheers

csv is an excel file
i have 21 csv excel files all should change the format as .xlsx how to do that

Hi @anjani_priya

Read the Excel & write to csv

Hi @anjani_priya

Yesterday Anil & everyone explained the same logic of for each file in a folder use the same logic here. & Put the code given by him in above post. Try on your own. You will learn quickly.

@anjani_priya

Just so that you know …a little googling also will help

now coming to c hanging all use a loop around

cheer

1 Like


no change reflected

@anjani_priya

did you give the correct path?

are csv present?

just tried same

one is csv and one is excel

Please check properly

cheers

Capture65

@anjani_priya

please use a log message inside and check if it is looping any files and if the folder path is correct or not

cheers


its looping but format is not changing

@anjani_priya

A new file will be created with smae name…please try to open the folder and sort by name and check two files with same name should be present in the folder one with .csv and other with .xlsx

cheers

no it didn’t created

@anjani_priya

Can you share your xaml here…i can try from my end…with few example files also would help

Also if this does not work please go with using read cav and then write daatatable to excel activities

Cheers

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