How can I copy the all data from the 1stFile.xlsx to another excel file particularly the words “Name”, “Age”, and “Section”?
We can use MOVE FILE activity like mention the file path of this file in Path property and the destination property with another file path
To do it in a typical way like this
—Use excel application scope and pass the file path of the excel
— inside the scope use Read range activity and get the output with a variable of type datatable named dt
—now use WRITE RANGE activity from WORKBOOK activities and mention the file path and datatable dt as input and enable add headers property in the property panel
Try both use of Read Range and use of Write Range with checking AddHeaders.
Use wookbook activities
1.Use Read range in properties panel check headers check box create output data table variable.
2.Use Write range activity in properties panel check add headers and pass data table variable.
Use Excel Activities
1.Use Excel application scope pass the path of the excel file.
2.Next use Read Range activity create output data table variable.
3.And then use Write Range in properties panel check add headers activity pass the data table variable.
You have many options to do it.
1. Copy the sheet to another file using Copy To File activity.
2. Copy the data to clipboad and past into another excel file
Write range activity in properties panel check add headers you will get column names.