jQuery导出excel实现

最新推荐文章于 2024-04-22 16:07:00 发布

「已注销」

最新推荐文章于 2024-04-22 16:07:00 发布

阅读量2.4k

点赞数 1

分类专栏： jQuery 文章标签： jquery

本文链接：https://blog.csdn.net/m0_50623581/article/details/108565627

版权

jQuery 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

获取数据，并调用导出

 function chickMe(e) {
            $.ajax({
                async:true,
                type: 'POST',
                url: 'http://localhost:20422/api/DPPM/DPPM_Export',
                //url: 'http://10.67.50.80/TJWebApi/api/DPPM/DPPM_Oper',
                contentType: "application/json;charset=utf-8", //json格式传给后端               
                data: JSON.stringify({
                    FactoryID: e.getAttribute("data-FactoryID"),
                    PNs: e.getAttribute("data-partno"),
                    WOs:e.getAttribute("data-WOs"),
                    EventPoint : e.getAttribute("data-EventPoint"),
                    Categoryname : e.getAttribute("data-Categoryname"),
                    dateS: e.getAttribute("data-dateS"),
                    dateE: e.getAttribute("data-dateE"),
                 }),
                dataType: "json",//数据返回格式

                success: function (data) {
                    console.log(data);
                    if (data.status==0){
                        var title=[{sysserialno:'sn'},{failureeventpoint:'工站'},{lasteditdt:'时间'},{workorderno:'工单'},
                        {skuno:'Pn'},{productdesc:'productdesc'},{field1:'field1'},{description:'ActionDescription'},
                        {newpartno:'newpartno'},{failurepartsn:'failurepartsn'},{newpartsn:'newpartsn'}]; 
                        toExcel(e.getAttribute("data-partno")+new Date().toLocaleString(),data.data,title)
                    }
                    else{
                        alert (data.message)
                    }
                },
                error: function (err) {
                    console.log(err);
                    alert('程序错误');
                }
            });
        }

导出toExcel函数

function toExcel(FileName, JSONData, ShowLabel) {  
            //先转化json  
            var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;  
            var excel = '<table>'; 
            //设置表头  
            var row = "<tr align='left'>";//设置Excel的左居中
            for (var i = 0, l = ShowLabel.length; i < l; i++) {  
                for (var key in ShowLabel[i]) {
                    row += "<td>" + ShowLabel[i][key] + '</td>';  
                }
            }  
            //换行  
            excel += row + "</tr>"; 
            //设置数据  
            for (var i = 0; i < arrData.length; i++) {  
                var rowData = "<tr align='left'>"; 

                for (var y = 0; y < ShowLabel.length; y++) {
                    for(var k in ShowLabel[y]){
                        if (ShowLabel[y].hasOwnProperty(k)) {
                             rowData += "<td style='vnd.ms-excel.numberformat:@'>" + (arrData[i][k]===null? "" : arrData[i][k]) + "</td>";　　　　　　　　　　　　　　　　　 //vnd.ms-excel.numberformat:@ 输出为文本
                        }
                    }
                }

                excel += rowData + "</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);  
        }

如果只导出页面table中的内容，用

function outEx (){
            $("#Results").table2excel({
                    exclude: ".noExl",
                    name: "Excel Document Name",
                    filename: "myFileName",
                    exclude_img: true,
                    exclude_links: true,
                    exclude_inputs: true
                })
        }

但是需要引入

<script src="JS/jquery.table2excel.js"></script>

「已注销」

关注

1
点赞
踩
8

收藏

觉得还不错? 一键收藏
1
评论
jQuery导出excel实现

获取数据，并调用导出 function chickMe(e) { $.ajax({ async:true, type: 'POST', url: 'http://localhost:20422/api/DPPM/DPPM_Export', //url: 'http://10.67.50.80/TJWebApi/api/DPPM/DPPM_Oper',
复制链接

扫一扫