I was looking for the solution on how to add new sheets into an existing Excel Workbook, but as far as I understood, using such methods as openpyxl engine and pd.ExcelWriter is suitable for local files.
How can I automate the same thing for files stored at Sharepoint? I read information from them, I re-write data on already existing sheets, but I specifically need to create/add new sheets too.
I'd prefer to use python, but if there are scripts in VBA or other languages that I can use for the solution - great!
Thank you in advance!