Python Forum

Full Version: Need to compare the Excel file name with a directory text file.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
*)Read the excel file and iterate through rows. The first column has "File Name"
*)Read the file name and check the PDF file with the same name available in the folder
*)If the file is present then write the result as "File found" in .txt
*)Also copy the respective links, column B and column C values and write in .txt file
*)If the file is not present then write the result as "File not found" in .txt file

I want to compare and perform the task. Appreciate it if you share any thoughts.
What have you tried so far? Please show code working or not, and specific question about where it fails.