Python Forum
Need to compare the Excel file name with a directory text file.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need to compare the Excel file name with a directory text file.
#1
Thumbs Up 
*)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.

Attached Files

Thumbnail(s)
   
Reply
#2
What have you tried so far? Please show code working or not, and specific question about where it fails.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  How can I write formatted (i.e. bold, italic, change font size, etc.) text to a file? JohnJSal 12 28,080 Feb-13-2025, 04:48 AM
Last Post: tomhansky
  How to write variable in a python file then import it in another python file? tatahuft 4 943 Jan-01-2025, 12:18 AM
Last Post: Skaperen
  Problems writing a large text file in python Vilius 4 1,006 Dec-21-2024, 09:20 AM
Last Post: Pedroski55
  Get an FFMpeg pass to subprocess.PIPE to treat list as text file? haihal 2 1,038 Nov-21-2024, 11:48 PM
Last Post: haihal
  JSON File - extract only the data in a nested array for CSV file shwfgd 2 1,077 Aug-26-2024, 10:14 PM
Last Post: shwfgd
  FileNotFoundError: [Errno 2] No such file or directory although the file exists Arnibandyo 0 944 Aug-12-2024, 09:11 AM
Last Post: Arnibandyo
  docx file to pandas dataframe/excel iitip92 1 2,582 Jun-27-2024, 05:28 AM
Last Post: Pedroski55
  "[Errno 2] No such file or directory" (.py file) IbrahimBennani 13 6,402 Jun-17-2024, 12:26 AM
Last Post: AdamHensley
  Reading an ASCII text file and parsing data... oradba4u 2 1,434 Jun-08-2024, 12:41 AM
Last Post: oradba4u
  How to Randomly Print a Quote From a Text File When User Types a Command on Main Menu BillKochman 13 4,315 Apr-24-2024, 05:47 AM
Last Post: Bronjer

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020