+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: Need to compare the Excel file name with a directory text file. (/thread-38980.html)
Need to compare the Excel file name with a directory text file. - veeran1991 - Dec-15-2022
*)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.
RE: Need to compare the Excel file name with a directory text file. - Larz60+ - Dec-15-2022
What have you tried so far? Please show code working or not, and specific question about where it fails.