Specifies the name of the document library that contains the Excel file you want to connect to.

Data Type

string

Default Value

""

Remarks

This property specifies the name of the document library that contains the Excel file the server connects to.

If you do not set this property, the server defaults to using the "Shared Documents" library.

To connect to OneDrive for Business, set this property to "Documents".

If your SharePoint site uses a language other than English, enter the localized name of the document library. For example, in French-language SharePoint sites, the library might be named "Documents partagés".

To find the correct library name:

1. Navigate to your SharePoint site collection.
2. Open the document library page.
3. Click the settings (gear) icon and select Library settings.
4. Under List Information, look for the Web Address field.
5. The last segment in the web address typically reflects the library name.

For example, if your SharePoint site is in French, the URL might look like this: https://YourSharePointSite/subSites/.../Documents%20partages/Forms/AllItems.aspx

In this case, the document library name is Documents partagés.

Use this property when your Excel file is stored outside the default library or in a OneDrive for Business account.