Determines how the provider renders values in the output.

Possible Values

Data Type

string

Default Value

"FormattedValue"

Remarks

Allowed values are:

• FormattedValue: Values are calculated and formatted in the reply according to the cell's formatting. Formatting is based on the workbook's locale, not the requesting user's locale. For example, if A1 is 1.23 and A2 is "=A1" and formatted as currency, then A2 would return "$1.23".
• UnformattedValue: Values are calculated but not formatted in the reply. For example, if A1 is 1.23 and A2 is "=A1" and formatted as currency, then A2 would return the number 1.23.

  Note: When TypeDetectionScheme is set to RowScan, the provider determines the data types based on the data returned by the API. Since date and time fields are returned by the API as int/double (for example, November 15, 2025 is stored as 45954 in Microsoft Excel Online's 1900 date system), the provider detects these fields as integers rather than dates when using RowScan. To ensure proper date/time detection, set TypeDetectionScheme to ColumnFormat when using the UnformattedValue option.

• Formula: Values are not calculated and instead the reply includes the formulas. For example, if A1 is 1.23 and A2 is "=A1" and formatted as currency, then A2 would return "=A1". For this reason, every column containing a formula will be exposed as String type regardless of the set TypeDetectionScheme.