This Python script takes two paths to folders and compares file names inside them, then it writes result into an Excel file.
os
- Python standard moduleopenpyxl
- Library
- Set the values for
folder_path1
,folder_path2
, andoutput_file
variables according to your requirements. - Ensure that the
openpyxl
library is installed (pip install openpyxl
if not already installed). - Run the script.
- The merged list of file names will be written to the specified Excel file.
Note: Ensure that the folders and files exist and the script has the necessary permissions to read from the folders and write to the output file.