Creating a FlexGrid Table from JSON which contains cells coordinates

Creating a FlexGrid Table from JSON which contains cells coordinates

Posted by: nan0br3aker on 20 March 2018, 10:13 pm EST

• 

  nan0br3aker

  • Post Options:
  • Link
    Copy

  Posted 20 March 2018, 10:13 pm EST

  Hello everyone!

  I have following task, I have a JSON which constains a lot of Cells with their coordinates and values, how can I build a FlexGrid Table by using it?

  Here is an example of my JSON (ignore Cols,HeaderZList & CellContext), as you can see there are Cells with coordinates(Col, Row):

  {
    "Cols":[
  
    ],
    "Cells":[
      {
        "Col":1,
        "IsEditable":false,
        "Type":"string",
        "Cols":1,
        "Sortable":false,
        "Filterable":false,
        "Value":" Some header text",
        "Row":1,
        "IsHeader":true,
        "Rows":1
      },
      {
        "Col":2,
        "IsEditable":false,
        "Type":"string",
        "Cols":1,
        "Sortable":false,
        "Filterable":false,
        "Value":" Some header text",
        "Row":1,
        "IsHeader":true,
        "Rows":1
      },
      {
        "Col":3,
        "IsEditable":false,
        "Type":"string",
        "Cols":1,
        "Sortable":false,
        "Filterable":false,
        "Value":"Some header text",
        "Row":1,
        "IsHeader":true,
        "Rows":1
      },
      {
        "Col":1,
        "IsEditable":false,
        "Type":"string",
        "Cols":1,
        "Sortable":false,
        "Filterable":false,
        "Value":"Some header text",
        "Row":2,
        "IsHeader":true,
        "Rows":1
      },
      {
        "Col":2,
        "IsEditable":true,
        "Type":"",
        "Cols":1,
        "Sortable":false,
        "Filterable":false,
        "Value":"70,000",
        "Row":2,
        "IsHeader":false,
        "CellContext":{
          "endDate":"2017-12-31",
          "conceptId":460304,
          "closedAxisList":[
  
          ],
          "openAxisesList":[
  
          ],
          "startDate":"2017-12-31"
        },
        "Rows":1
      },
      {  }
    ],
    "HeaderZList":[
  
    ]
  }
  

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 22 March 2018, 2:11 am EST

  Hi,

  Please refer to the answer to this post here

  https://www.grapecity.com/en/forums/wijmo/angularjs-initializing-fle#this-is-not-the-recommende