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);}
阅读全文
1 0
- easyui datagrid 导出excel
- EasyUI----DataGrid 导出 Excel
- easyui datagrid 导出Excel
- 实现easyui的datagrid导出为excel
- 实现easyui的datagrid导出为excel
- easyUI datagrid导出excel(所见即所得)
- 实现easyui的datagrid导出为excel
- easyui-datagrid-JavaScript-导出Excel、合并单元格
- easyui的datagrid导出为excel
- easyui Jquery datagrid 导出Excel(转)
- easyUI datagrid数据导出为Excel
- 实现easyui的datagrid导出为excel
- easyui datagrid 导出excel及乱码解决
- easyui datagrid标题和数据 导出excel
- jquery easyui datagrid纯js导出到excel
- 实现easyui的datagrid导出为excel,已处理导出乱码
- easyui datagrid 增删改查分页 导出 先上传后导入 NPOI批量导入 导出EXCEL
- DataGrid导出为Excel
- 用tracert等工具分析网站访问速度慢的原因
- HDU 3612 Find a way【简单搜索bfs】
- nginx之负载均衡
- 从CMD进入MySql,以及PHP连接数据库时的字符串设置
- 极光推送Demo
- easyui datagrid 导出Excel
- 1251. 【USACO题库】1.4.3 Arithmetic Progressions等差数列
- 整个推荐系统用到的知识
- HTML5+flash打造兼容各浏览器的文件上传方案
- Codeforces Round #427 (Div. 2)
- 3309: DZY Loves Math
- 依赖JDK的Java软件运行问题
- C语言生成指定长度随机字符串
- C# 多线程