username = 'myUsername'
password = 'myPassword'
r = requests.get(file, auth=HTTPBasicAuth(myUsername, myPassword))
output = open('test.xlsx', 'wb')
output.write(resp.content)
output.close()
Read xlsx stored on sharepoint location with openpyxl in python?