Cmdlets for Microsoft Excel Online

Build 25.0.9434

IncludeSharePointSites Parameter (Connect-ExcelOnline Cmdlet)

Specifies whether or not drives for all SharePoint sites are retrieved when querying Drives view. (Note: This property only affects Drives views.

Syntax

Connect-ExcelOnline -IncludeSharePointSites SwitchParameter

Data Type

bool

Default Value

false

Remarks

If True, the cmdlet retrieves all Site IDs recursively, and for each of them issues a separate call to get their drives. Be aware that setting this property to True may decrease performance for the Drives view.

Note: If the AuthScheme is AzureServicePrincipal and IncludeSharePointSites is set to True, you must also set the SharePointAccessToken or OAuthJWTCert connection property in order to query views such as SharePointSites.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434