RPA Challenge.zip (122.4 KB)
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.
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
The fields are not in tabular format.
Your can use [Balareva.CSV.Activities] to do it.
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