r/pythonhelp • • Aug 25 '21

Openpyxl and Pandas - pulling data from excel files

Hey guys, I am a fairly new python user and am trying to learn new modules for working with excel workbooks and sheets. I am trying to use openpyxl, xlsxwriter and pandas to take some password protected excel documents and pull specific data from cells and then have that spit out into a "Master Output" document that the script also creates.

So my workflow would be [Multiple excel workbooks in a directory] -> [Python would create a new workbook] -> [Specific cells from the workbooks would be copied to the new workbook then the new workbook is saved]

I have been able to read the filenames in a list using glob and also writing the data from the old excel sheets to a new one using xlsxwriter, but I am having trouble connecting all the different parts.

Any help with how to get all the smaller parts connected into one would be great!

2 Upvotes

0 comments sorted by