The os module provides functionalities for interacting with the operating systems. Print("The location of the files to rename does not exist.As shown in the example, we can rename a file in Python using the rename() method available in the os module. # Error if folder path for documents to be renamed doesn't exist. Print("The document containing the file names does not exist.") # Error message if file names workbook doesn't exist. # Check if its the file or folder path that doesn't exist. Print(str(filesRenamed) + " files renamed successfully.") Print(str(filesRenamed) + " file renamed successfully.") Print("The file names workbook could not be saved.") # Message stating file names workbook could not be saved. # Add message stating file does not exist. # Add message stating file already renamed. elif os.path.isfile(pathDocsRename + newFileName # Check if file has already been renamed. # Two columns to the right of the original file name. # Add message stating no new file name provided. # Check if new file name has been provided. # Add message stating no new valid name provided. + str(row)].value = "File could not be renamed." # Add message stating file can't be renamed. + str(row)].value = "File has been renamed." XlNamesWorksheet[(chr(ord(xlNamesWorksheetCol) + 2)) # Add message stating file has been renamed. PathDocsRename + newFileName + fileExtension) Shutil.move(pathDocsRename + currentFileName + fileExtension, + fileExtension) and not newFileName is None: if os.path.isfile(pathDocsRename + currentFileName # Check if the file exists and a new name has been provided. NewFileName = xlNamesWorksheet[(chr(ord(xlNamesWorksheetCol) + 1)) # New file name one column to the right of current file name.ĬurrentFileName = xlNamesWorksheet[xlNamesWorksheetCol # Make sure there is a value in selected cell. for row in range(2, xlNamesWorksheet.max_row + 1): # Process rows from the second to the last. # Check if there are any files to rename. # File extension for documents to rename. XlNamesWorksheet = xlNamesWorkbook.worksheets Print("Unable to open file names workbook.") # Message stating that workbook can't be opened. XlNamesWorkbook = openpyxl.load_workbook(pathNamesDoc) # Open the file names workbook and assign to a variable.
if os.path.isfile(pathNamesDoc) and os.path.exists(pathDocsRename):
# Check if the file and folder paths exist. XlNamesWorksheet = None # Path to documents to rename. PathNamesDoc = "C:\\Demo\\Rename\\Documents to rename.xlsx" Finally, ‘try-except’ blocks are used to handle errors with opening, saving and closing files. Overall feedback is also given as to the total number of files renamed. If they do exist, the document containing the file names is opened and the file name information on the first sheet is processed. The current and new file names are extracted from column ‘A’ and the next column to the right, column ‘B’. A check is made to see if the file exists with the current name and if it does the file gets renamed to the new name, providing there is one available. Feedback is added as to whether the file was renamed or not, or, if it had already been renamed, in the second column to the right of the original file name. Existing File Nameįirst of all, the path to the above document, as well as to the files to be renamed, is set and a check is made to see if they exist. Column ‘A’ contains the existing file name, without the file extension, column ‘B’ contains the new file name, if available, without the extension, and column ‘C’ is for notes to be added during the renaming process. In the example below, a spreadsheet called “Documents to rename.xlsx” contains the file name information. If it is necessary to rename a batch of files, where both the existing and new file names exist in an Excel spreadsheet, Python can be used to automate the renaming process. Batch File Search and Renaming with Python
0 kommentar(er)
