I am hoping someone can help me please.
Below is the code I have to combine 3 dataframes and export it as an excel file locally to my own computer:
output = pd.ExcelWriter(r"FILEPATH")
headcount_raw.to_excel(output, sheet_name='Headcount_Raw')
YTD_Mobility.to_excel(output, sheet_name='YTD_Mobility')
Future_Mobility.to_excel(output, sheet_name='Future_Mobility')
output.save()
Now this works fine, but in order for me to scale out the Python RPA to the wider team I need to be able to run the code from files withinin SharePoint and rather than exporting it to my own computer I want to do the same as in extract all 3 dataframes in an excel file and save it in a location within a SharePoint folder.
I have tried the above code in the version for SharePoint but cant get it to work.
If someone has a use case similar to this I would appreciate your time to run me through the code you have or support me in this.
Thank you in advance!
KR
Koys