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, RawData Type
cstr
Default Value
"UserEntered"
Remarks
Determines how the cmdlet parses values the user submits to Microsoft Excel Online.
Raw | The values the user has entered will not be parsed and will be stored as-is. |
UserEntered | The 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. |