本文實(shí)例講述了asp.net+Ligerui實(shí)現(xiàn)grid導(dǎo)出Excel和Word的方法。，具體如下：
下面采用的導(dǎo)EXCEL方法，適合不翻頁(yè)的grid，而且無(wú)需再讀一次數(shù)據(jù)庫(kù)，對(duì)于翻頁(yè)的grid來(lái)說(shuō)，要導(dǎo)全部，當(dāng)然后臺(tái)要再讀一次數(shù)據(jù)庫(kù)，這種導(dǎo)EXCEL方法baidu一大堆，這里不重復(fù)
代碼部分:
grid.htm：
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" ><head> <title></title> <link href="../lib/ligerUI/skins/Aqua/css/ligerui-all.css" rel="stylesheet" type="text/css" /> <link href="../lib/ligerUI/skins/ligerui-icons.css" rel="stylesheet" type="text/css" /> <script src="../lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script> <script src="../lib/ligerUI/js/plugins/ligerGrid.js" type="text/javascript"></script> <script src="../lib/ligerUI/js/plugins/ligerToolBar.js" type="text/javascript"></script> <script src="../lib/ligerUI/js/plugins/ligerDialog.js" type="text/javascript"></script> <script src="AllProductData.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $("#toptoolbar").ligerToolBar({ items: [ {text: '導(dǎo)出Excel',id:'excel',icon:'print',click:itemclick}, {text: '導(dǎo)出Word' ,id:'word',icon:'print',click:itemclick} ] }); $("#maingrid").ligerGrid({ columns: [ { display: '主鍵', name: 'ProductID', type: 'int', totalSummary:{type: 'count'}}, { display: '產(chǎn)品名', name: 'ProductName', align: 'left', width: 200 }, { display: '單價(jià)', name: 'UnitPrice', align: 'right', type:'float',totalSummary:{render: function (suminf, column, cell){return '<div>最大值:' + suminf.max + '</div>';},align: 'left'}}, { display: '倉(cāng)庫(kù)數(shù)量', name: 'UnitsInStock', align: 'right', type: 'float',totalSummary:{type: 'sum'}} ], dataAction: 'local', data: AllProductData, sortName: 'ProductID', showTitle: false, totalRender: f_totalRender, width: '100%', height: '100%',heightDiff:-10 }); $("#pageloading").hide(); }); function f_totalRender(data, currentPageData) { return "總倉(cāng)庫(kù)數(shù)量:"+data.UnitsInStockTotal; } function itemclick(item) { grid = $("#maingrid").ligerGetGridManager(); if(item.id) { switch (item.id) { case "excel":$.ligerDialog.open({url: "../service/print.aspx?exporttype=xls"});return; case "word":$.ligerDialog.open({url: "../service/print.aspx?exporttype=doc"});return; } } } </script></head><body style="padding:0px; overflow:hidden; height:100% "> <div id="toptoolbar"></div> <div id="maingrid" style="margin:0; padding:0"></div> <div style="display:none;"></div></body></html>
新聞熱點(diǎn)
疑難解答
圖片精選
