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
  "[Errno 2] No such file or directory" (.py file) IbrahimBennani 13 670 Jun-17-2024, 12:26 AM
Last Post: AdamHensley
  Reading an ASCII text file and parsing data... oradba4u 2 226 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 1,478 Apr-24-2024, 05:47 AM
Last Post: Bronjer
  very newbie problem on text file zapad 2 412 Apr-12-2024, 06:50 PM
Last Post: zapad
  Compare current date on calendar with date format file name Fioravanti 1 423 Mar-26-2024, 08:23 AM
Last Post: Pedroski55
  Python openyxl not updating Excel file MrBean12 1 508 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 598 Feb-07-2024, 12:24 PM
Last Post: Viento
  file open "file not found error" shanoger 8 1,530 Dec-14-2023, 08:03 AM
Last Post: shanoger
  Search Excel File with a list of values huzzug 4 1,426 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 1,024 Nov-03-2023, 05:13 PM
Last Post: noisefloor

Forum Jump:

User Panel Messages

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