Read json data and save it as .xlsx file and then use load the data

Read json data and save it as .xlsx file and then use load the data

Posted by: nemili.tulsiraj on 27 August 2020, 11:07 am EST

• 

  nemili.tulsiraj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 27 August 2020, 11:07 am EST

  Hi,
  
  I have a json data which I mapped to hidden wijmo grid I am try to convert it into a .xlsx file use without download using save and saveAysnc .
  
  While using save it gives me
  
  Assertion failed in Wijmo: Please use JSZip 2.5 to save excel files synchronously. Error

  Sample Code:

  const book = wjcGridXlsx.FlexGridXlsxConverter.save(this.tempgrid, {
        includeColumnHeaders: false,
        includeRowHeaders: false
      });
  book.sheets[0].name = 'FlexGrid Data';
  book.save('FlexGrid-Export.xlsx');
  

  while using saveAsync
  
  it is downloading a file which i don’t want .And is not consistent sometime to data is populated and sometime data is blank.

  Using the result of save/saveAsync I want to populate another grid .

  So is there way way to convert the json into .xlxs file without downloading which I can pass it to loadAsync function

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 28 August 2020, 2:38 am EST

  Hello,
  
  For this, you need to avoid the save the files with the name provided. You may load this book to the FlexGrid using the load method.
  
  Please refer to the following demo sample:
  
  http://jsfiddle.net/mkgupta911/wwz60q3j/19/

  Regards,
  
  Manish Gupta

• 

  nemili.tulsiraj

  • Post Options:
  • Link
    Copy

  Posted 2 September 2020, 3:39 am EST

  Hi,
  
  Manish Thanks . It resolves my issue thanks for your support .