ValueInputOption Parameter (Connect-GoogleSheets Cmdlet)
Determines how inserted values should be treated.
Syntax
Connect-GoogleSheets -ValueInputOption string
Possible Values
UserEntered, RawData Type
cstr
Default Value
"UserEntered"
Remarks
| 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 Google Sheets UI. |