CacheLocation Parameter (Connect-ExcelOnline Cmdlet)
Specifies the path to the cache when caching to a file.
Syntax
Connect-ExcelOnline -CacheLocation string
Data Type
cstr
Default Value
"%APPDATA%\\CData\\ExcelOnline Data Provider"
Remarks
The CacheLocation is a simple, file-based cache. The cmdlet uses SQLite.
If left unspecified, the default location is "%APPDATA%\\CData\\ExcelOnline 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 Microsoft Excel Online catalog in CacheLocation.