Posted 25 February 2021, 6:14 am EST
Hi,
In our application, previously we were using Farpoint Excel.IO to convert Spread.Net instance to Spread Js instance. Now, we have replaced Farpoint with gc documents for Spread JS 13/14.
When we were using Farpoint Excel.IO-
For the hidden rows, the size of the row is set to 0 (By default it was 17).
Now, with the gc document implementation, it sets the property visible false, and don’t set the size of the row.
Please refer below code for the gc document implementation -
inpRptBaseManager - IForm
inpRptBaseManager.Spread.SaveExcel(stream, FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat);
stream.Position = 0;
var workbook = new GrapeCity.Documents.Excel.Workbook(GCDocumentsLicenseKey);
workbook.Open(stream);
var json = workbook.ToJson();
Json Result for rows with ExcelIO for Rows -
“rows”: [
{
“size”: 60
},
{
“size”: 41
},
{
“size”: 54
},
{
“size”: 17
},
{
“size”: 17
},
{
“size”: 17
},
{
“size”: 17
},
{
“size”: 17
},
{
“size”: 17
},
{
“size”: 17
},
{
“size”: 0
},
{
“size”: 0
},
{
“size”: 17
}
]
JSON Result for rows with gc document -
“rows”: [
{
“size”: 60
},
{
“size”: 41
},
{
“size”: 54
},
{},
{},
{},
{},
{},
{},
{},
{
“visible”: false
},
{
“visible”: false
},
{}
],
How can we get the same result using gc document as we were getting using ExcelIO?
