Spread Sheet JSON data has empty DataTable

Spread Sheet JSON data has empty DataTable

Posted by: rtiwari on 24 July 2020, 9:59 am EST

• 

  rtiwari

  • Post Options:
  • Link
    Copy

  Posted 24 July 2020, 9:59 am EST

  Hi,
  
  We have bought spread sheet designer code and now we are able to render designer plus spreadsheet. We put the entire spread in Iframe and inside the iframe I have written a method to fetch the state in json format.
  
  I am writing below line of code to achieve this.

  
  (function() {
    'use strict';
    var spread = new GC.Spread.Sheets.Workbook(
      document.getElementById('ss'),
    );
    var spreadsheetData = JSON.stringify(
      spread.toJSON({ includeBindingSource: true }),
    );
  
    console.log('exported state', spreadsheetData);
  })();
  
  

  It is returning a json however the dataTable node is empty.

  "data": {"dataTable: {}"} ... 
  

  I am making sure that below line is called once and it is correctly pointing to the instance of the spreadsheet.

   var spread = new GC.Spread.Sheets.Workbook(
      document.getElementById('ss'),
    );
  

  So please help me what am I missing? I am getting the json however the spread sheet cell data is not coming. This is little urgent issue for us. Need your guide.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 July 2020, 3:04 am EST

  Hi Rupesh,

  You do not need to use the spread workbook constructor, spread instance is created for us by the designer. You may get the spread instance used by the designer like:

  var designer = GC.Spread.Sheets.Designer;
  var spread = designer.wrapper.spread;
  

  After getting the spread instance, you may simply use the toJSON method

  var spreadsheetData = JSON.stringify(
      spread.toJSON({ includeBindingSource: true }),
    );
  

  Regards
  
  Sharad

• 

  rtiwari

  • Post Options:
  • Link
    Copy

  Posted 29 July 2020, 3:31 pm EST

  Thanks Sharad this worked for me.

• 

  rtiwari

  • Post Options:
  • Link
    Copy

  Posted 29 July 2020, 3:36 pm EST

  Now I have another 2 issues:
  
  1- Spread sheet is not resizing. I have spreadsheet opening in jquery dialog inside iframe. When I am resizing the jquery dialog I am also updating the iframe height & width however the spread sheet is not resizing. It is disappearing and its height is becoming very less. I tried calling disigner.wrapper.reset() still not working. I debugged and found the

  updateLayout

  method is getting called in index/index.js file but that is not fixing the resize. please help here.

  2- We also want to remove couple of tabs from the designer ribbon. However we I remove HTML from ribbon.html then designer is not rendering properly. Do you have any guide line how can I hide settings tab, illustration div. what is the steps to do that ?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 July 2020, 2:50 am EST

  1). You need to call spread.refresh() method after resizing to update the spread’s layout according to new dimensions.

  var designer = GC.Spread.Sheets.Designer;
  var spread = designer.wrapper.spread;
  spread.refresh();
  

  2). Could you please let us know what issue you are facing when removing tabs from ribbon.html. It should work fine. To remove the settings tab, we need to update ribbon.html file and remove div whose id is “settingsTab” and li item which contains link to settingsTab div i.e

• SETTINGS
.

Please make sure that you have removed both of these elements and let us if you face any issues.