Hi,
In my application, I need to use spreadsheet control and want to bind data with each cell of spreadsheet. For example, I have sample json data like
[
{
“Row”: 1,
“Column”: “A”,
“Data”: “Test1”
},
{
“Row”: 2,
“Column”: “A”,
“Data”: “Test2”
}
]
I want to fit this data with spreadsheet control. I did explore all properties and methods of Spreadsheet control but could not find suitable way to bind data with specific cell. I also visited github page – https://github.com/iceteagroup/wisej-demobrowser to explore spreadsheet control data binding under project Wisej.Web.Ext.Syncfusion2.Demo but it does not give me direction of achieving what I am looking for.
Could anyone please help me with binding in memory data to spreadsheet or any helpful documentation. Please do not suggest me syncfusion documentation because I have already explore it and it doesn’t help me much.
Thanks & Regards,
Vaishali
Hi Vaishali,
Thanks for reaching out to support.
If you have a given Row and Column, you can apply the cell value using this method:
https://ej2.syncfusion.com/documentation/api/spreadsheet/#updatecell
this.spreadsheet1.Instance.updateCell(new { value = "myValue" }, "A3");
If you’re looking to open the entire (json) file you have defined in the format above, you must convert it into Syncfusion’s document JSON format and then call
this.spreadsheet1.Instance.openFromJson(new { file = syncfusionJsonObject });
https://ej2.syncfusion.com/documentation/api/spreadsheet/#openfromjson
Unfortunately, we don’t provide support OOTB for converting formats.
If you need technical support on this I recommend reaching out to sales AT wisej DOT com to purchase a consulting package.
Best regards,
Levie
Hi Vaishali,
We’re currently looking into this and we’ll get back to you ASAP!
Best,
Alaa
Please login first to submit.