ValueInputOption
Determines how the provider parses values the user submits to Microsoft Excel Online.
Possible Values
UserEntered, RawData Type
string
Default Value
"UserEntered"
Remarks
Determines how the adapter 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. |