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

GrapeCity.Documents.Excel.IWorkbook.ToJson

ToJson Method

ToJson(SerializationOptions)

Generates a JSON string from the workbook by using the specified serialization 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 that controls serialization behavior.
Returns
Type Description
string

The JSON string generated from the workbook.
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)

Serializes the workbook to JSON and writes the content to the specified stream.

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 output stream that receives the JSON content.
SerializationOptions serializationOptions

The SerializationOptions object that controls serialization behavior.
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());