asp.net+Ligerui实现实现grid导出导出Excel和和Word的方法的方法
本文实例讲述了asp.net+Ligerui实现grid导出Excel和Word的方法。分享给大家供大家参考，具体如下：
下面采用的导EXCEL方法，适合不翻页的grid，而且无需再读一次数据库，对于翻页的grid来说，要导全部，当然后台要再读
一次数据库，这种导EXCEL方法baidu一大堆，这里不重复
代码部分:
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: '导出Excel',id:'excel',icon:'print',click:itemclick},
{text: '导出Word' ,id:'word',icon:'print',click:itemclick}
] });
$("#maingrid").ligerGrid({
columns: [
{ display: '主键', name: 'ProductID', type: 'int', totalSummary:{type: 'count'}},
{ display: '产品名', name: 'ProductName', align: 'left', width: 200 },
{ display: '单价', name: 'UnitPrice', align: 'right', type:'float',totalSummary:{render: function (suminf, column, cell){return '<div>最大值:' + suminf.max +
'</div>';},align: 'left'}},
{ display: '仓库数量', 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 "总仓库数量:"+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>
导出页面print.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="print.aspx.cs" Inherits="example" EnableEventValidation = "false"
ValidateRequest="false" %>
<html>
<head>
<title></title>
<link href="../lib/ligerUI/skins/aqua/css/ligerui-all.css" rel="stylesheet" type="text/css" />
评论0
最新资源