Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Ensure all necessary dependencies are installed

  2. 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

  3. In the Main_file column, fill in the name of the coversheet followed by a comma, followed by the name of the file

  4. In the Additional_files file column, fill in the names of any supplementary files

  5. Download the script:

    View file
    nameFile_combine_tool.py

  6. Double click on the script or type in command prompt python File_combine_tool.py

  7. Browse and select the Excel file containing the list of files to be combined.

  8. Browse and select the input folder containing the files listed in the Excel file.

  9. Browse and select the output folder where the combined files will be saved.

  10. Click the "Combine Files" button to start the file combination process.

  11. Once the process is complete, a message box will indicate successful completion, and the program will close after pressing OK.

  12. Once the process is complete, check if all the files are in the output folder.

  13. 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.

  14. Check the same thing for extent. Error- “Please fill manually”. Do it manually.

...