Onedrive domain ending in .us instead of .com #1810
Description
OS (e.g. Windows 10 or macOS Sierra)
Windows 10
Versions of xlwings, Excel and Python (e.g. 0.11.8, Office 365, Python 3.7)
0.26.1, Excel version 2201, Python 3.8.8
Describe your issue (incl. Traceback!)
Cannot run xlwings python code in folders synched to onedrive. However our commercial onedrive domain is of the form https://COMPANYNAME-my.sharepoint.us NOT .com
After modifying line 452 in utils.py to:
pattern = re.compile(r'https://[^-]-my.sharepoint.us/[^/]/[^/]/[^/]/(.*)')
I was able to get it to work in our environment. I don't have a code snippet for handling .com AND .us domains, but hopefully that is enough for an easy drop in solution
.