file = (
    """https://content.potatocompany.com/workspaces/PotatoTeam/Shared Documents/XYZ errors/XYZ Errors_Confirm.xlsx"""
    )
urllib.request.urlretrieve(file, 'test.xlsx')
Read xlsx stored on sharepoint location with openpyxl in python?