Data transfer between the Excel files.
Input: Valid path to the Excel sheet should be provided
Process:
- Step1: Open the source Excel file and get the path of the file.
- Step2: Store the path in the variable.
- Step3: Get the data in the variable from source Excel.
- Step4: Open destination Excel and get the path of the file.
- Step5: Give the sheet name and store the variable data in that Excel file.
- Step6: Save and close the Excel file.