Dev Shed Forums - Python Programming Python Programming forum discussing coding techniques, tips and tricks, and Zope related information. Python was designed from the ground up to be a completely object-oriented programming language. en Fri, 21 Sep 2018 03:57:48 GMT vBulletin 60 Dev Shed Forums - Python Programming <![CDATA[Worksheets doesn't get processed when files to be processed are more than 1]]> Fri, 24 Aug 2018 04:58:21 GMT Hi Guys,

My issue is when ever I copy worksheets from 1 file to another it works, but not from 1 file to multiple files. To elaborate further, if files to be copied are more than 1, copy doesn't work stuck on 1st file, but if listing are reversed last file in list get's copied information. Here is the section of code that gives me problem

        str = ''.join(match)
        for root, dirs, files in os.walk(os.path.abspath(str)):
                for file in reversed(files):
                        jobno_files_found = os.path.join(root, file)
                        print("files found: ", jobno_files_found)                       
                        wb2 = openpyxl.load_workbook(jobno_files_found)
                        print("wb2.sheetnames: ", wb2.sheetnames)
                        for jobno_found in wb2.sheetnames:
                                print("jobno_found: ", jobno_found)
                                temp_sheet = template[jobno_found] #Add Sheet name

The code runs showing all sheets per file when last 2 lines are removed, but when lines are included sheet not found error is coming from code below, which doesn't makes sense since sheets are seen above.

temp_sheet = template[jobno_found] #Add Sheet name
Any help or advice is greatly appreciated, thanks. ]]>
Python Programming begood321