Cmdlets for Microsoft Excel Online

Build 23.0.8839

ValueInputOption Parameter (Connect-ExcelOnline Cmdlet)

Determines how the provider parses values the user submits to Microsoft Excel Online.

Syntax

Connect-ExcelOnline -ValueInputOption string

Possible Values

UserEntered, Raw

Data Type

cstr

Default Value

"UserEntered"

Remarks

Determines how the 本製品 parses values the user submits to Microsoft Excel Online.

RawThe values the user has entered will not be parsed and will be stored as-is.
UserEnteredThe values will be parsed as if the user typed them into the UI. Numbers will stay as numbers, but strings may be converted to numbers, dates, etc., following the same rules that are applied when entering text into a cell via the Excel Online UI.

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