Hi There,

Would you like to open the xlsx files mannualy, one by one, or using a loop?

Would you please share what you have got as code for the moment?

If you need to work with xlsx file you will need to install and import xlsxwriter library.

Other useful libraries to manipulate excel files include:

openpyxl, pandas, xlrd, xlwt, xlutils

Useful links:

http://www.python-excel.org/

https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html

import xlsxwriter
for f in range (1, 11):
    workbook = xlsxwriter.Workbook('source folder' + str(f) + '. File.xlsx')

The code could be structured in away to rename the file once appended with say "r" for read. The newly generated files from the tool will not have it. Therefore when you loop thru the files in the source folder you will consider only these without "r" flag in the name.

import os
import xlsxwriter
import pandas as pd

rootdir = 'D:/Users/Desktop/excel_test/'

# code use for testing purposes to simulate the automated file generation tool
#for f in range (1, 11):
#    workbook = xlsxwriter.Workbook( rootdir + str(f) + '.File.xlsx')
    
    
for subdir, dirs, files in os.walk(rootdir):
    for file in files:
        if '_r' not in file:
            
            source = rootdir + file

            # open file and extract data
            # for example: df = pd.read_excel(source, sheet_name='Sheet1')
            # once the excel data is in a pandas dataframe you can use libraries such as seaborn or matplotlib for data visualisation
            
            old_name = os.path.splitext(file)[0]
            new_name = old_name.replace(old_name, old_name+'_r.xlsx')   
            os.rename(source, rootdir + new_name)

Recently, I needed to send some important files that I prepared with an accountant for our client, but I didn't want to send them using mail or any messengers. By googling, I've found great services, software and tools, click here to find more info, that are free and easy to use. It is amazing that now everything is already there to make doing business easy and safe.