easyui datagride导出excel表格
来源:互联网 发布:2015好听的网络歌曲 编辑:程序博客网 时间:2024/06/07 21:32
function daochu(JSONData, ReportTitle, ShowLabel) {
var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData)
: JSONData;
var CSV = '';
//CSV += ReportTitle + '\r\n\n';
CSV += ReportTitle+ '\r\n';
if (ShowLabel) {
var row = "";
for (var index in arrData[0]) {
row += index + ',';
}
row = row.slice(0, -1);
CSV += row + '\r\n';
}
for (var i = 0; i < arrData.length; i++) {
var row = "";
for (var index in arrData[i]) {
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,' + escape(CSV);
var uri = 'data:text/csv;charset=utf-8,\ufeff' +encodeURI(CSV); //解决乱码
var link = document.createElement("a");
link.href = uri;
link.style = "visibility:hidden";
link.download = fileName + ".xls";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData)
: JSONData;
var CSV = '';
//CSV += ReportTitle + '\r\n\n';
CSV += ReportTitle+ '\r\n';
if (ShowLabel) {
var row = "";
for (var index in arrData[0]) {
row += index + ',';
}
row = row.slice(0, -1);
CSV += row + '\r\n';
}
for (var i = 0; i < arrData.length; i++) {
var row = "";
for (var index in arrData[i]) {
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,' + escape(CSV);
var uri = 'data:text/csv;charset=utf-8,\ufeff' +encodeURI(CSV); //解决乱码
var link = document.createElement("a");
link.href = uri;
link.style = "visibility:hidden";
link.download = fileName + ".xls";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
$("#daochu").click(function () {
var data = JSON.stringify($('#tblst').datagrid('getData').rows);
var data = JSON.stringify(Enumerable.From($("#tblst").datagrid("getRows")).Select("val,x=>{条形码:val.BarCode,原厂编码:val.Code,货品名称:val.ProName,型号:val.ProModel,规格:val.Spec,货品类型:val.TypeName,产地:val.OriginPlace,计量单位:val.Unit,售价:val.SellPrice,仓库:val.WarehouseName,仓位:val.ShippingspaceName,当前库存:val.Stock,盘点库存:val.InventoryStock,损益数量:val.IncreaseNum,损益:val.Increase,损益原因:val.Reason}").ToArray());
if (data == '')
return;
daochu(data, "data", true);
});
阅读全文