I am using a pdf to excel converter where I scrape some values from the spreadsheet once converted. However, an error occurs when I try and paste this to another spreadsheet – “source files contain some invalid XML”.

However, if I manually open and save the excel file prior to running the python code, it works fine.

I have tried wb1.save() and close() but the code still won’t run.

Is there a way to code so that I don’t have to manually save?

Thanks in advance.

I have tried wb1.save() and close() but the code still won’t run.