Skip to content

Helpful code for tedious process of copying files from directory using excel workbook to match the nearest name.

Notifications You must be signed in to change notification settings

Karim-KM/Extract

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 

Repository files navigation

Extract Files from folder using python script and excel workbook to search for files

Requirements

  • python pandas
  • python shutil

usage 🛠

usage: Extract.py [-h] [-p PATH] [-ext EXTENTION] [-xl EXCEL] [--ignore-existing]

File Extractor based on workbook list Create Excel file with name 'List' and two columns 'Name' and 'Number'

options:
-h, --help            show this help message and exit
-p PATH, --path PATH  Folder that contins the files (default: None)
-ext EXTENTION, --extention EXTENTION
                        Folder that contins the files (default: None)
-xl EXCEL, --excel EXCEL
                        Folder that contins the files (default: None)
--ignore-existing     skip files that exist (default: False)

To-do's ✅

  • Validate on files that exists.

Hope this script proves useful to somebody else!

About

Helpful code for tedious process of copying files from directory using excel workbook to match the nearest name.

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages