Replied 30 March 2021, 11:26 pm EST
in our project we are facing the same "issue" which is as you said "working as designed".
In our case we are creating the excel on the server side (.Net Core 3.1 with GrapeCity.Documents.Excel 3.2.2) and then serialize it to JSON and sending it via HTTP to the Frontend (Angular 10, SpreadJS 13.2.3).
It results in:
System.ArgumentException: The JSON value of length 168634408 is too large and not supported.
at System.Text.Json.ThrowHelper.ThrowArgumentException_ValueTooLarge(Int32 tokenLength)
at System.Text.Json.Utf8JsonWriter.WriteStringValue(ReadOnlySpan`1 value)
at System.Text.Json.Serialization.Converters.JsonConverterString.Write(Utf8JsonWriter writer, String value, JsonSerializerOptions options)
Can you recommend another approach?