r/pythonhelp • u/yahoozit • 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!