GrapeCity.Documents.Excel.IWorksheet.ToJson

ToJson Method

ToJson(SerializationOptions)

Generates a JSON string from the worksheet.

Serializes the current worksheet to JSON and applies the specified SerializationOptions during serialization. If serializationOptions is null, the worksheet is serialized with internally created default options.

Declaration

string ToJson(SerializationOptions serializationOptions = null)

Function ToJson(Optional serializationOptions As SerializationOptions = Nothing) As String

Parameters

Type	Name	Description
SerializationOptions	serializationOptions	The SerializationOptions object to apply during serialization; may be `null`.

Returns

Type	Description
string	The JSON string that represents the worksheet.

Examples

worksheet.Range["A1:B2"].Value = new object[,] {
    {"Name", "Value"},
    {"Test", 100}
};
SerializationOptions options = new SerializationOptions();
options.IgnoreStyle = true;
string json = worksheet.ToJson(options);

ToJson(Stream, SerializationOptions)

Generates a JSON stream from a worksheet.

Declaration

void ToJson(Stream stream, SerializationOptions serializationOptions = null)

Sub ToJson(stream As Stream, Optional serializationOptions As SerializationOptions = Nothing)

Parameters

Type	Name	Description
Stream	stream	The specified JSON stream.
SerializationOptions	serializationOptions	the SerializationOptions object.

Examples

worksheet.Range["A1"].Value = "Sample";
MemoryStream stream = new MemoryStream();
worksheet.ToJson(stream);