Cmdlets for Microsoft Excel Online

Build 24.0.9060

Other Parameter (Connect-ExcelOnline Cmdlet)

These hidden properties are used only in specific use cases.

Syntax

Connect-ExcelOnline -Other string

Data Type

cstr

Default Value

""

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Caching Configuration

CachePartial=TrueCaches only a subset of columns, which you can specify in your query.
QueryPassthrough=TruePasses the specified query to the cache database instead of using the SQL parser of the cmdlet.

Integration and Formatting

DefaultColumnSizeSets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMTDetermines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filenameRecords the underlying socket data transfer to the specified file.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060