ADO.NET Provider for Microsoft SharePoint Excel

Build 22.0.8462

CacheLocation

Specifies the path to the cache when caching to a file.

Data Type

string

Default Value

"%APPDATA%\\CData\\Microsoft SharePoint Excel Data Provider"

Remarks

The CacheLocation is a simple, file-based cache. The provider uses SQLite.

If left unspecified, the default location is "%APPDATA%\\CData\\Microsoft SharePoint Excel Data Provider" with %APPDATA% being set to the user's configuration directory:

Platform %APPDATA%
Windows The value of the APPDATA environment variable
Mac ~/.config
Linux ~/.config

See Also

  • AutoCache: Set to implicitly create and maintain a cache for later offline use.
  • CacheMetadata: Set to persist the Excel Services catalog in CacheLocation.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462