Specifies whether to use sessions when connecting to Excel Online through the Microsoft Graph API.

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the provider creates a persistent session with the Graph API for Excel Online, improving data consistency and performance for multiple operations.

When this property is set to true, sessions will also be used for metadata operations (listing tables and columns) if the workbook is larger than 15 MiB. This does not apply if WorkbookId is specified, since the workbook size is not known in that context.

When UseSessions is set to false, each operation uses its own session instead of reusing a persistent one, which can reduce performance and data consistency.

Important: Always close connections when finished. Failure to do so prevents the session from being terminated and can lead to unnecessary server resource consumption.

It is recommended to keep this option enabled (default) for optimal performance and data reliability.