[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.Workbook.FromJson

FromJson Method

FromJson(string, DeserializationOptions)

Loads workbook content from a SpreadJS JSON (SSJSON) string into this workbook.

Use this method to control deserialization behavior with a DeserializationOptions instance. The returned list contains any JsonError objects found during deserialization.

Declaration
public IList<JsonError> FromJson(string json, DeserializationOptions deserializationOptions = null)
Public Function FromJson(json As String, Optional deserializationOptions As DeserializationOptions = Nothing) As IList(Of JsonError)
Parameters
Type Name Description
string json

The SpreadJS JSON (SSJSON) string to load into this workbook. Must not be null.
DeserializationOptions deserializationOptions

The DeserializationOptions object that controls how the JSON content is deserialized. If null, default deserialization options are used.
Returns
Type Description
IList<JsonError>

A list of JsonError objects found during deserialization.
Implements
Examples
worksheet.Range["A1"].Value = "Name";
worksheet.Range["B1"].Value = "Test";
string json = workbook.ToJson();
DeserializationOptions options = new DeserializationOptions();
IList<JsonError> errors = workbook.FromJson(json, options);

FromJson(Stream, DeserializationOptions)

Loads workbook content from a SpreadJS JSON (SSJSON) stream into this workbook.

Use this method to control deserialization behavior with a DeserializationOptions instance. The returned list contains any JsonError objects found during deserialization.

Declaration
public IList<JsonError> FromJson(Stream stream, DeserializationOptions deserializationOptions = null)
Public Function FromJson(stream As Stream, Optional deserializationOptions As DeserializationOptions = Nothing) As IList(Of JsonError)
Parameters
Type Name Description
Stream stream

The input stream that provides the SpreadJS JSON (SSJSON) content to load. Must not be null.
DeserializationOptions deserializationOptions

The DeserializationOptions object that controls how the JSON content is deserialized. If null, default deserialization options are used.
Returns
Type Description
IList<JsonError>

A list of JsonError objects found during deserialization.
Implements
Examples
worksheet.Range["A1"].Value = "Name";
string json = workbook.ToJson();
DeserializationOptions options = new DeserializationOptions();
options.DoNotRecalculateAfterLoad = true;
IList<JsonError> errors = workbook.FromJson(
    new MemoryStream(System.Text.Encoding.UTF8.GetBytes(json)),
    options
);