GrapeCity.Documents.Excel.DeserializationOptions

DeserializationOptions Class

Represents options that control how workbook or worksheet content is deserialized from JSON.

Use this class to configure JSON loading behavior for APIs such as FromJson(string, DeserializationOptions) and Open(string, DeserializationOptions). You can use these options to ignore styles, ignore formulas, or prevent recalculation after the JSON data is loaded.

Inheritance

object

DeserializationOptions

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public class DeserializationOptions

Public Class DeserializationOptions

Examples

string jsonText = workbook.ToJson();
DeserializationOptions options = new DeserializationOptions();
options.IgnoreStyle = true;
options.IgnoreFormula = true;
workbook.FromJson(jsonText, options);

Constructors

Name	Description
DeserializationOptions()	Initializes a new instance of the DeserializationOptions class.

Properties

Name	Description
DoNotRecalculateAfterLoad	Gets or sets whether to skip marking formulas dirty after loading JSON data. This option is used by JSON deserialization APIs such as FromJson(string, DeserializationOptions) and Open(string, DeserializationOptions). The default value is false. When this property is true, formulas are not marked dirty after loading, so the formula results loaded from JSON are returned when calculation is triggered. When this property is false, formulas are marked dirty after loading, so formula results are recalculated when calculation is triggered. Calculation can be triggered by operations such as getting formula values or calling Calculate().
IgnoreFormula	Gets or sets whether formulas are ignored when deserializing a workbook or worksheet from JSON. If this property is `true`, formula information in the JSON data is ignored during deserialization. The default value is `false`.
IgnoreStyle	Gets or sets whether styles are ignored when a workbook or worksheet is deserialized from JSON. If this property is `true`, style information in the JSON data is ignored during deserialization. The default value is `false`.
InvalidFormulaHandling	Gets or sets how invalid formulas are handled when deserializing JSON data. The default value is `null`.