CSV conversion to Excel file

Help
1

RPA Challenge.zip (122.4 KB)

Hi,
I have a csv file. I need to convert the data inside it to data in excel file. I am using generate datatable and trying to get a datatable and using write range to get the excel file. But not getting the desired output. If anyone could help me plzz to get the data.

2

You don’t need to use generate application if the fields are in tabular format.
Just use read CSV and then excel application scope and write range to write it to excel. Just try this once @Shashi123

3

The fields are not in tabular format.

4

@Shashi123

Your can use [Balareva.CSV.Activities] to do it.

image
image1347×751 75 KB

At first you need to create excel file with format table that you want and input excel file path to [CSV to Excel] activity.

This activity will get data in CSV file and input it to Excel file.

Please refer to the following

image
image1017×673 36.8 KB

1 Like