I just want to read a excel file in Sharepoint, but with no authentication.
Read a sharepoint excel file using the file link, without a authentication.
If you don't need to authenticate (or program the authentication in), to download, you can try requests.get(url="link")
or you could use selenium, to browse the website, and download the file.
And then you can open it with pandas.
Python - how to read Sharepoint excel sheet without authentication