SpreadJS Excel to Ssjson format using c#

SpreadJS Excel to Ssjson format using c#

Posted by: damansape on 8 September 2017, 10:00 am EST

• 

  damansape

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:00 am EST

  Hi,

  I need your help for the below:

  I want to convert Ms-excel file into the ssjson file with the help of c#(Not through the asp.net as on the front end I am using spreadjs angular plugin). So to populate spread I should send ssjson to the client end from the server side. Also if is there anyway to evaluate all the formulas before converting to ssjson, if yes then please share any sample code.

  Thanks In Advance
  
  Daman

• 

  slawyer

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:00 am EST

  Hi,

  You can use the Importer and Exporter classes in C# to convert from Excel format to ssjson. Here’s some sample code in Windows Forms:
  
  http://sphelp.grapecity.com/webhelp/SpreadJSWeb/webframe.html#excelexample.html
  
  That same code should work fine in other targets.
  
  I think formulas do not get recalculated when loading the Excel document or saving to ssjson, and there isn’t any API for recalculating or querying the spreadsheet model; you have to load the ssjson into the SpreadJS widget in the client script, then the formulas will recalculate and you can use the client script API to access the spreadsheet model.

  Regards,
  
  -Sean