GrapeCity.Documents.Excel.Workbook.ToJson

ToJson Method

ToJson(SerializationOptions)

Generates a JSON string from the workbook by using the specified serialization options.

Declaration

public string ToJson(SerializationOptions serializationOptions = null)

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

Parameters

Type	Name	Description
SerializationOptions	serializationOptions	The SerializationOptions object.

Returns

Type	Description
string	The JSON string generated from the workbook.

Implements

IWorkbook.ToJson(SerializationOptions)

Examples

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

ToJson(Stream, SerializationOptions)

Generates a JSON stream from the workbook.

Declaration

public void ToJson(Stream stream, SerializationOptions serializationOptions = null)

Public 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.

Implements

IWorkbook.ToJson(Stream, SerializationOptions)

Examples

worksheet.Range["A1:B2"].Value = new object[,] {
    {"Name", "Value"},
    {"Test", 100}
};
MemoryStream stream = new MemoryStream();
SerializationOptions serializationOptions = new SerializationOptions();
serializationOptions.IgnoreStyle = true;
workbook.ToJson(stream, serializationOptions);
string json = System.Text.Encoding.UTF8.GetString(stream.ToArray());