How to copy data from csv without headers and paste it to existing excel file with headers

Help Studio
,
1

Hi ,

I work in a project where I need to copy a data rows from CSV to another excel file which already has headers and prebuilt formulas.

hope to copy the data from csv file with out headers ? please help

2

@monishanair2010

Try the below workflow

Example.zip (10.1 KB)

3

You read the CSV into a datatable with headers. The headers become column names. If the CSV doesn’t have a first row of headers there’s a box in the Read CSV activity that controls that.

Then you use Append Range to write to the Excel file.

These are basic things that are covered in the free UiPath training on their web site. I highly recommend doing that training.