I am trying to do copy CSV file into excel file but getting error. Looks like some setting wrong. I tried to use excel file.
Can you please provide screenshots of the file, the workflow and the error?
Use the Read CSV activity to read the csv file and store it in to a datatable variable.
After that use write range workbook activity to write the datatable to the excel file, pass the datatable variable in the write range workbook activity. If you want to use use excel file you can use in that use the write range activity to write the datatable to the excel.
Regards,
- Use Read CSV activity to read the file and store it an data Table.
- Write Data Table to Excel under Excel Process scope to write the same data to excel.
Hope it might help you!!
Regards,
Read csv activity to read the data from the file
Write range workbook to write the data
You can directly use “Write Data Table to Excel” activity and delete Copy/Paste Range.
Regards,
Use csv activities for reading and workbook for writing to excel instead of using excel activities.
@Parvathy what to write inside “What to write”
I guess sheet name should be used in Destination section.
while Using read CSV activity you will storing it an data table that data table variable will be used here.
Regards
@Parvathy Read CSV: The CSV file format for C:\Users\samraat.maharjan\Desktop\Merchant Dispute\Account Statement.csv is invalid. Line 3 contains more values than the header line. I got this error when I used to output of csv in “What to write”