How to export a jqgrid to excel02.11.18

var XLSX = require('xlsx');
var FileSaver = require('file-saver');

function get_date() {
  var d = new Date();
  var str = pad_str(d.getFullYear()) +
  pad_str(1 + d.getMonth()) +
  pad_str(d.getDate()) +
  pad_str(d.getHours()) +
  pad_str(d.getMinutes()) +
  pad_str(d.getSeconds());
  return(str);
}

function pad_str(i) {
  return (i < 10) ? "0" + i : "" + i;
}

function s2ab(s)
{
  var buf = new ArrayBuffer(s.length); //convert s to arrayBuffer                                                                                                    
  var view = new Uint8Array(buf);  //create uint8array as viewer                                                                                                     
  for (var i=0; i<s.length; i++) view[i] = s.charCodeAt(i) & 0xFF;
  return buf;
}

.jqGrid('navButtonAdd', '#grid_toppager', {
        caption: "Excel",
        buttonicon: "ui-icon-save",
        onClickButton: function ()
        {
           let data    = jQuery(this).jqGrid("getGridParam", "lastSelectedData");
           let ws_data = [];
           let header  = [];
           let names   = [];
           let date    = get_date();
           console.log(date);
           for(let i=0;i < columns.length;i++)
           {
             header.push(columns[i]['label']);
             names.push(columns[i]['name']);
           }
           ws_data.push(header);

for(let i=0;i < data.length;i++)
           {
             let v = [];
             for(let ii in names)
             {
                v.push(data[i][names[ii]]);
             }
             ws_data.push(v);
           }

}
    });

});

https://redstapler.co/sheetjs-tutorial-create-xlsx/

Anonymous

How to export a jqgrid to excel02.11.18

Information Epoch 1779156098