easyui datagrid 导出Excel

来源:互联网 发布:算法导论这本书怎么样 编辑:程序博客网 时间:2024/06/08 00:21

jsp: 

<a onclick="exportExcel()" id="export" class="ui-btn">导出</a></span>
js:
function exportExcel() {    var data = JSON.stringify($('#grid').datagrid('getData').rows);    console.log(data);    if (data == '')        return;    JSONToCSVConvertor(data, "计划单列表", true);}function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel) {     var unixTimestamp = new Date(form.billDate);     var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;      var CSV = '';      CSV += ReportTitle + '\r\n\n';      if (ShowLabel) {         row = row.replace(/createTime/g, "创建时间").replace(/updateTime/g,"更新时间").replace(/updateBy/g, "更新人").replace(/deleted/g,"订单删除标志").replace(/ver/g, "版本号").replace(/product/g,"商品名称")              .replace(/qty/g, "质量").replace(/weight/g,"重量").replace(/index/g,"序号");          row = row.slice(0, -1);          CSV += row + '\r\n';      }      for (var i = 0; i < arrData.length; i++) {          var row = form.billNo+","+form.stock.name+","+unixTimestamp.format("yyyy-MM-dd")+",";          for ( var index in arrData[i]) {              if (arrData[i].id == undefined){ //去除空行                  row = "";                  break;              }              row += '"' + arrData[i][index] + '",';           }          row.slice(0, row.length - 1);          CSV += row + '\r\n';      }      if (CSV == '') {          alert("Invalid data");          return;      }      var fileName = "MyReport_";      fileName += ReportTitle.replace(/ /g, "_");      var uri = 'data:text/csv;charset=utf-8,' + encodeURI(CSV);      var link = document.createElement("a");      link.href = uri;      link.style = "visibility:hidden";      link.download = fileName + ".csv";      document.body.appendChild(link);      link.click();      document.body.removeChild(link);}

原创粉丝点击