I am copying data from excel file and getting that as a datatable. Now I want to paste it to a template CSV file where I already have the headers.
I want to paste the datatable from A2 cell and save the csv file as a new file, so that the template file can be empty and can be reused every time.
Can anyone please give me an idea on this?
copy you template file first and save it in different name, use that for pasting your data table, so your template file will be always there untouched.
Also, in the write range property, you can specify the starting cell as A2, you can uncheck AddHeaders property if you dont want the headers from the datatable as you already have headers in your csv file which you copied from your template. hope this helps.