Posted 8 September 2017, 1:05 am EST
Hello,
is there demo shown how to use Spreadjs Design to set template(Column /format/ fomula etc.) and feed the data with json from server side?
Thanks
Forums Home / Spread / SpreadJS
Posted by: sha-purchase2016 on 8 September 2017, 1:05 am EST
Posted 8 September 2017, 1:05 am EST
Hello,
is there demo shown how to use Spreadjs Design to set template(Column /format/ fomula etc.) and feed the data with json from server side?
Thanks
Posted 8 September 2017, 1:05 am EST
Hi,
Using SpreadJS.Sheets Designer you can create the template and save it as ssjson, then load that template using fromJSON. It is also easy to get the template ssjson from an instance of SpreadJS.Sheets using toJSON. Please see the tutorial demo sample Spread fromJSON/toJSON which show these APIs in action.
SpreadJS.Sheets templates can contain cell bindings to json data, or you can use sheet or table binding to load json fetched from the server. Please see the tutorial demo samples for Sheet-Level Binding, Cell Binding, and Table Binding. There is also a feature demo sample which very nicely shows off both sheet-level binding and cell-level binding to a template in the feature demo sample for cell-level binding.
Regards,
-Sean
Posted 13 October 2020, 3:25 am EST
All the links included for binding are broken. We find only examples for cell binding. Can you please update the links for table binding and sheet binding.
Posted 13 October 2020, 4:53 pm EST
Please use the following links:
• toJSON: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Workbook~toJSON.html
• fromJSON: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Workbook~fromJSON.html
• JSON serialization/deserialization demo: https://www.grapecity.com/spreadjs/demos/features/workbook/json-serialization/purejs
• Cell data binding: https://www.grapecity.com/spreadjs/demos/features/data-binding/cell-level-binding/purejs
• Sheet binding: https://www.grapecity.com/spreadjs/demos/features/data-binding/sheet-level-binding/purejs
• Table binding: https://www.grapecity.com/spreadjs/demos/features/data-binding/table-binding/purejs
Regards