Useing spreadjs as headless -non ui mode

Useing spreadjs as headless -non ui mode

Posted by: g.kiriazidis on 16 July 2022, 2:45 am EST

• 

  g.kiriazidis

  • Post Options:
  • Link
    Copy

  Posted 16 July 2022, 2:45 am EST

  Is it possible to use spreadjs on the server side as a headless component without the UI.
  
  Let me give an example.
  
  I create an excel file with a model to calculate score for a quiz.
  
  This excel mode is stored server side .I mean the json representation with formulas, data model , etc.
  
  From a html page user submits a quiz with answers (the quiz front is not using spreadjs , just plain html css ).
  
  The server gets the submitted quiz , passes it into the excel model stored on the server , calculates score and returns back the model with calculations performed from the excel model.
  
  The client uses this returned model from the http response to display scores on the client.

  Something like this library claims to do :
  
  https://hyperformula.handsontable.com/#what-is-hyperformula

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 July 2022, 7:36 am EST

  Hi Yiannis,

  You can use the SpreadJS on server side like Node.js Application. SpreadJS provides enough APIs to set the cell values and retrieve the calculations based on the operations performed or using the formulas.

  You can refer to the following blog that describes using SpreadJS with Node.js Application: https://www.grapecity.com/blogs/how-to-generate-excel-spreadsheets-in-nodejs

  Regards
  
  Ankit

• 

  jybleau

  • Post Options:
  • Link
    Copy

  Posted 22 December 2023, 1:32 pm EST

  Hello, the blog link on how to use spreadjs in NodeJS is broken.

  Is there another link on that subject?

  Looking forward for using SpreadJS if it can be used in Node to create Excel files.

  Thanks

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 26 December 2023, 8:47 am EST

  Hi,

  You can refer to the below blog link, which provides insights into using SpreadJS with a Node.js application.

  Link : https://developer.mescius.com/blogs/how-to-import-export-excel-xlsx-using-node-js

  I have attached a sample to refer.

  Best regards,

  Ankit

  test.zip