...
Ensure all necessary dependencies are installed
If the spreadsheet that you’re working on doesn’t already contain columns AD, Main_file, and AE, Additional_file, add those columns to it
In the Main_file column, fill in the name of the coversheet followed by a comma, followed by the name of the file
In the Additional_file files column, fill in the names of any supplementary files
Download the script:
View file name File_combine_tool.py Double click on the script or type in command prompt python File_combine_tool.py
Browse and select the Excel file containing the list of files to be combined.
Browse and select the input folder containing the files listed in the Excel file.
Browse and select the output folder where the combined files will be saved.
Click the "Combine Files" button to start the file combination process.
Once the process is complete, a message box will indicate successful completion, and the program will close after pressing OK.
Once the process is complete, check if all the files are in the output folder.
Check excel file. If file is not combined properly or some error is encountered, it will show “Please combine files manually” instead of the filename. Combine these files manually then.
Check the same thing for extent. Error- “Please fill manually”. Do it manually.
...