You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Include a minimal code sample to reproduce the issue (and attach a sample workbook if required!)
Running the following code works fine with resource1, but not with resource2.
importxlwingsasxwimportosresource1=rf'{os.path.expanduser('~')}\MYCOMPANYNAME\SITE 1 - Documents\document1.xlsx'resource2=rf'{os.path.expanduser('~')}\MYCOMPANYNAME\SITE 2 - Documents\document2.xlsx'# Connect to the Excel filewb=xw.Book(resource2)
# Access the desired sheetsheet=wb.sheets['Sheet1']
# Read the data from the sheetdata=sheet.used_range.value
Next, I've added a user-scope variable SHAREPOINT_WIN of value %USERPROFILE%\MYCOMPANYNAME\SITE 2 - Documents\ - after restarting all applications and re-running, the issues remains to be the same. Any help is greatly appreciated.
The text was updated successfully, but these errors were encountered:
OS (e.g. Windows 10 or macOS Sierra)
Tested with Windows 10 and Windows 11
Versions of xlwings, Excel and Python (e.g. 0.11.8, Office 365, Python 3.7)
xlwings 0.31.1, Excel Version 2401, Python 3.12.2
Describe your issue (incl. Traceback!)
I have multiple SharePoint document repositories synchronized.
C:\Users\MYUSERNAME\MYCOMPANYNAME\SITE 1 - Documents
C:\Users\MYUSERNAME\MYCOMPANYNAME\SITE 2 - Documents
Include a minimal code sample to reproduce the issue (and attach a sample workbook if required!)
Running the following code works fine with resource1, but not with resource2.
Next, I've added a user-scope variable SHAREPOINT_WIN of value %USERPROFILE%\MYCOMPANYNAME\SITE 2 - Documents\ - after restarting all applications and re-running, the issues remains to be the same. Any help is greatly appreciated.
The text was updated successfully, but these errors were encountered: