纯前台js json导出到excel,不与后台交互
来源:互联网 发布:淘宝认证照的正确示范 编辑:程序博客网 时间:2024/05/16 15:57
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=utf-8">
- <script type="text/javascript" src="jquery.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function(){
- $('#wwo').click(function(){
- var data = {"title":[{"value":"集团", "type":"ROW_HEADER_HEADER", "datatype":"string"}, {"value":"日期", "type":"ROW_HEADER_HEADER", "datatype":"string"}],"data":[[{"value":"好好", "type":"ROW_HEADER"}, {"value":"2015-08-24", "type":"ROW_HEADER"}]]};
- if(data == '')
- return;
- JSONToExcelConvertor(data.data, "Report", data.title);
- });
- });
- function JSONToExcelConvertor(JSONData, FileName, ShowLabel) {
- //先转化json
- var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
- var excel = '<table>';
- //设置表头
- var row = "<tr>";
- for (var i = 0, l = ShowLabel.length; i < l; i++) {
- row += "<td>" + ShowLabel[i].value + '</td>';
- }
- //换行
- excel += row + "</tr>";
- //设置数据
- for (var i = 0; i < arrData.length; i++) {
- var row = "<tr>";
- for (var index in arrData[i]) {
- var value = arrData[i][index].value === "." ? "" : arrData[i][index].value;
- row += '<td>' + value + '</td>';
- }
- excel += row + "</tr>";
- }
- excel += "</table>";
- var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
- excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel; charset=UTF-8">';
- excelFile += '<meta http-equiv="content-type" content="application/vnd.ms-excel';
- excelFile += '; charset=UTF-8">';
- excelFile += "<head>";
- excelFile += "<!--[if gte mso 9]>";
- excelFile += "<xml>";
- excelFile += "<x:ExcelWorkbook>";
- excelFile += "<x:ExcelWorksheets>";
- excelFile += "<x:ExcelWorksheet>";
- excelFile += "<x:Name>";
- excelFile += "{worksheet}";
- excelFile += "</x:Name>";
- excelFile += "<x:WorksheetOptions>";
- excelFile += "<x:DisplayGridlines/>";
- excelFile += "</x:WorksheetOptions>";
- excelFile += "</x:ExcelWorksheet>";
- excelFile += "</x:ExcelWorksheets>";
- excelFile += "</x:ExcelWorkbook>";
- excelFile += "</xml>";
- excelFile += "<![endif]-->";
- excelFile += "</head>";
- excelFile += "<body>";
- excelFile += excel;
- excelFile += "</body>";
- excelFile += "</html>";
- var uri = 'data:application/vnd.ms-excel;charset=utf-8,' + encodeURIComponent(excelFile);
- 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);
- }
- </script>
- </head>
- <body>
- <input type="button" id="wwo" value="导出" />
- </body>
- </html>
阅读全文
0 0
- 纯前台js json导出到excel,不与后台交互
- 纯前台js json导出到excel,不与后台交互
- 前台到后台的交互,至成功导出Excel
- 纯js不经后台导出excel实例
- 纯js不经后台导出excel实例
- JSON前台与后台的交互
- js前台与后台数据交互-前台调后台
- js前台与后台数据交互-前台调后台
- js前台与后台数据交互-前台调后台
- 无服务端纯前台导出数据到Excel-JSExcelXML.js 使用指南
- excel前台导出json
- EXT 中json格式数据后台与前台的交互
- echarts后台与前台json数据交互问题
- js前台与后台数据交互-后台调前台(后台调用、注册客户端脚本)
- 3、web(js):js前台与后台数据交互-前台调后台
- 前台与后台数据交互
- 前台后台的的json数据交互
- jquery easyui datagrid纯js导出到excel
- 将数据从MySQL迁移到Oracle的注意事项
- iOS开发之Swift 4 JSON 解析指南
- ajax async和cache 参数
- TimePickerView 时间选择器
- 精通比特币
- 纯前台js json导出到excel,不与后台交互
- 高德地图之纯粹定位
- 7种方法解决移动端Retina屏幕1px边框问题
- 170705 逆向-RouterScan(2)
- RAID详解[RAID0/RAID1/RAID10/RAID5]
- 乐观锁限额控制
- Struts2框架使用及分析
- 附录3 pycoin库、ku程序和tx交易程序
- HTTP POST GET 本质区别详解