how to change csv file format to xlsx format in the same excel
how to make changes in the current excel file
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
cheers
csv is an excel file
i have 21 csv excel files all should change the format as .xlsx how to do that
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.
1 Like
Just so that you know …a little googling also will help
now coming to c hanging all use a loop around
cheer
1 Like
did you give the correct path?
are csv present?
just tried same
one is csv and one is excel
Please check properly
cheers
please use a log message inside and check if it is looping any files and if the folder path is correct or not
cheers
1 Like
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
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.