Copying contents of CSV file to Excel sheet

Learn Academy Feedback
1

Hi All,

I have recently started using excel automation & performed a demo to write contents of one excel file to the other. Now, I want to copy the data from CSV file (from one location) to an Excel file (another location). Is that possible to do ?
Can you please tell me what needs to be done here ?

Thanking you !

2

Is it possible to Read CSV and write Range to excel

1 Like
3

Hi Piyush,

if you check output of “read csv” activity,it is “datatable” , once you get the datatable you can use it in “write range activity” and all the data inside the datatable from csv will be written in the excel sheet you want to write.

1 Like