How to convert dynamic .csv to excel worksheet?

datatable
excel
csv

#1

I have a scenario which generates a dynamic .csv file.
After doing several automated calculations, i need to save it as excel worksheet.

How can I do this?


#2

hi @Hiranya

Why you wants to convert? any specific use?

You can use “Read CSV” Activity to get data from csv file and then perform your operations on that data whatever you wants to. or also

or also if you wants to use “Read Range” or other “Excel activities” on it then also you can use “.csv” files with Excel Application scope as well.

Regards…!!
Aksh


#3

Read the csv using “Read CSV” (check the delimiter), output it as datatable.
do the calculation on the datatable and store it in excel using Write Range(input as datatable).