Bind Sheet data using JSON having cell properties where data to be bind

Bind Sheet data using JSON having cell properties where data to be bind

Posted by: damco2015 on 8 September 2017, 10:07 am EST

• 

  damco2015

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 10:07 am EST

  Hi,

  Currently we are using big template with 20 tabs and in this we have to set data for around 15000 cells. First we load the template from JSON and then load the dynamic data of 15000 cells dynamically in loop which takes lot of time and makes our application un-usable.

  Is there any way build the data JSON with cell properties (row/column position, validator, editable/read-only etc.) and cell value, and load the JSON into spreadJS object with single line. By doing this, our loop will be removed and application will load template with data fast.

  Your help is much appreciated.

  Thanks,
  
  Naren

• 

  slawyer

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:07 am EST

  Hi,

  The full Spread json schema is documented here. You can build json which contains the “SheetModel” inside the “data” node of the “Sheet” node inside"sheets" which is inside the root “properties” node.

  However, for cases like you describe it is generally easier to use a sheet data source and table binding. In that case, you send the data for the target ranges as json, then use the table binding methods bindColumns and bindingPath; for details please see here. The json format for data binding is much simpler; for sample code please see here.

  Regards,
  
  -Sean

• 

  iloveckh

  • Post Options:
  • Link
    Copy

  Posted 15 January 2018, 12:20 am EST

  ddsfdsfds