Hello. I have a script which utilizes the win32com.client module and takes input from a spreadsheet to generate multiple word documents based on a standard template. This all works just fine in my dev environment, and with certain installations on other machines. When I try to package up the whole system, i've been running the basic pyinstaller myscript.py command. After it's packaged, I move the input and template files to the same directory as the exe, and some parts still work.
It seems like the Workbooks.Worksheets.Range() method doesn't work after I've packaged up. My code will register the win32com application object, and open up the input file. It will even read the data (I can see it output with logging statements), but when it gets to a line defining a range, it just stops. logging.debug(startCell.Address) #Reports correct value in the log logging.debug(endCell.Address) #Reports correct value in the log workingRange = InputSheet.Range(startCell, endCell).Value logging.info(workingRange) InputBook.Save() InputBook.Close() Through trial and error I've found that if I remove the "Value" the script will continue on to save and close the workbook, but will not log the data. I'm truly stumped, and I just don't get this error when running without pyinstaller. I can't share the full code without authorization from my company, but does any of this sound familiar? Thanks, -Ben -- You received this message because you are subscribed to the Google Groups "PyInstaller" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/pyinstaller. For more options, visit https://groups.google.com/d/optout.
