Flexsheet - Is there a way to export all data with post-calculated fields?

Flexsheet - Is there a way to export all data with post-calculated fields?

Posted by: rthiphav on 31 January 2019, 6:04 pm EST

• 

  rthiphav

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 31 January 2019, 6:04 pm EST

  I would like to extract all data from a flexsheet that has the fields calculated. I’m trying to create a customize XML spec with all data with calculated fields already calculated. Is there a way to do this?

  Example:
  
  My JSON looks like this. It has customize calculation functions AND built in calculate functions.
  
  “1”: “1.00”,
  
  “2”: “01000”,
  
  “3”: “Test”,
  
  “4”: “=MathFunc(18, "30.02", "2", 18, "30.02", "3", "+")”,
  
  “5”: “=MatchFunc(15, "24.00", "30.02")”,
  
  “6”: “=SUM(G5:AD5)”,
  
  I need it to somehow show the results in JSON, String, XML or anything that could be used like this.
  
  “1”: “1.00”,
  
  “2”: “01000”,
  
  “3”: “Test”,
  
  “4”: “10000”,
  
  “5”: “10000”,
  
  “6”: “20000”,
  
  Hope that makes sense. Any help is most appreciated.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2019, 12:30 am EST

  Hi,

  You may use the getCellValue() method to get the evaluated value of the cell.
  
  So to get all the evaluated data, we may iterate over each cell and get the evaluated value using the getCellValue() method and then build the JSON/String/XML schema as required.
  
  Please refer to the following doc for more info on getCellValue:
  
  https://demos.wijmo.com/5/Angular/WijmoHelp/WijmoHelp/topic/wijmo.grid.sheet.FlexSheet.Class.html#getCellValue

  ~Sharad