Export Data 

This demo illustrates exporting a grid into JSON, XML or CSV format (or any other format).

  • Get JSON and XML data  by built-in functions.
  • Get CSV data by customized function.
  • This feature allows users to import any Sigma Grid into their own programs, for example into spreadsheets.

Code

XML format

document.getElementById("TextArea1").value = grid.getValue().toXML('budget');

JSON format

document.getElementById("TextArea1").value = grid.getValue().toJSONString();

CSV format

var str = "";
var data = grid.getValue();
for(var i=0;i < data.length;i++){
    var rowArray = new Array();
    for(var j in data[i]){
        var value = "";
        switch (typeof data[i][j]) {
           case 'function':break;
           case 'object':break;
           default:
                value = '"' + data[i][j] + '"';
                rowArray.push(value); 
         }
    }
    str += rowArray.join(",") + "\n";
}
document.getElementById("TextArea1").value = str;

Export Data

 


All contents are (c) Copyright 2005 - 2007, Sigma Software Inc. All rights Reserved