asp.net+Ligerui实现grid导出Excel和Word的方法

来源：懂视网责编：小采时间：2020-11-27 22:37:50

asp.net+Ligerui实现grid导出Excel和Word的方法

asp.net+Ligerui实现grid导出Excel和Word的方法:本文实例讲述了asp.net+Ligerui实现grid导出Excel和Word的方法。分享给大家供大家参考，具体如下：下面采用的导EXCEL方法，适合不翻页的grid，而且无需再读一次数据库，对于翻页的grid来说，要导全部，当然后台要再读一次数据库，这种导EXCEL方法bai

推荐度：

点击下载本文 文档为doc格式

导读asp.net+Ligerui实现grid导出Excel和Word的方法:本文实例讲述了asp.net+Ligerui实现grid导出Excel和Word的方法。分享给大家供大家参考，具体如下：下面采用的导EXCEL方法，适合不翻页的grid，而且无需再读一次数据库，对于翻页的grid来说，要导全部，当然后台要再读一次数据库，这种导EXCEL方法bai

本文实例讲述了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" />
 <script src="../lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
 <script src="../lib/ligerUI1.1.0/js/ligerui.min.js" type="text/javascript"></script>
 <script type="text/javascript">
 function GetQueryString(name)
 {
 var reg = new RegExp("(^|&)"+name+"=([^&]*)(&|$)");
 var r= window.location.search.substr(1).match(reg);
 if (r!=null) return unescape(r[2]);return null;
 }
 function gethtml(g)
 {
 parent.$(".l-grid-header-table",g).attr("border","1");
 parent.$(".l-grid-body-table",g).attr("border","1");
 $("#hf").val(
 parent.$(".l-grid-header",g).html()+ //这里把表头捞出来
 parent.$(".l-grid-body-inner",g).html()+ //表身，具体数据
 parent.$(".l-panel-bar-total",g).html()+"<br/>"+ //这是全局汇总，1.1.0版本新添加的
 parent.$(".l-bar-text",g).html() //这是翻页讯息
 );
 parent.$(".l-grid-header-table",g).attr("border","0");
 parent.$(".l-grid-body-table",g).attr("border","0");
 // parent.$(".l-grid-header-table",g).removeAttr("border");
 // parent.$(".l-grid-body-table",g).removeAttr("border");
 }
 function init()
 {
 if (GetQueryString("exporttype")=="xls")
 {
 document.getElementById("btnxls").click();
 }
 else
 {
 document.getElementById("btndoc").click();
 }
 setTimeout(function ()
 {
 parent.$.ligerDialog.close();
 }, 3000);
 }
 </script>
</head>
<body style="padding:20px" onload="init()">
 <form id="form1" runat="server">
 导出中...
 <div style="visibility:hidden">
 <asp:Button ID="btnxls" runat="server" Text="导出Excel" onclick="Button1_Click" OnClientClick="gethtml('#maingrid')"/>
 <asp:Button ID="btndoc" runat="server" Text="导出Word" onclick="Button2_Click" OnClientClick="gethtml('#maingrid')"/>
 </div>
 <asp:HiddenField ID="hf" runat="server" />
 </form>
</body>
</html>

print.aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
namespace service
{
 public partial class print : System.Web.UI.Page
 {
 protected void Page_Load(object sender, EventArgs e)
 {
 if (!IsPostBack)
 {
 }
 }
 void exportexcel()
 {
 Response.Clear();
 Response.Buffer = true;
 Response.Charset = "utf-8";
 Response.AppendHeader("Content-Disposition", "attachment;filename=tmp.xls");
 Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
 Response.ContentType = "application/ms-excel";
 this.EnableViewState = false;
 System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
 System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
 oHtmlTextWriter.WriteLine(hf.Value);
 Response.Write(oStringWriter.ToString());
 Response.End();
 }
 void exportword()
 {
 Response.Clear();
 Response.Buffer = true;
 Response.Charset = "utf-8";
 Response.AppendHeader("Content-Disposition", "attachment;filename=tmp.doc");
 Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
 Response.ContentType = "application/ms-word";
 this.EnableViewState = false;
 System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
 System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
 oHtmlTextWriter.WriteLine(hf.Value);
 Response.Write(oStringWriter.ToString());
 Response.End();
 }
 protected void Button1_Click(object sender, EventArgs e)
 {
 exportexcel();
 }
 protected void Button2_Click(object sender, EventArgs e)
 {
 exportword();
 }
 }
}

原理:在点导出按钮的时候，弹一个print.aspx页面，这个页面把grid的html传给自己一个叫hf的hidden里面，然后后台response输出这个html

更多关于asp.net相关内容感兴趣的读者可查看本站专题：《asp.net文件操作技巧汇总》、《asp.net ajax技巧总结专题》及《asp.net缓存操作技巧总结》。

希望本文所述对大家asp.net程序设计有所帮助。

声明：本网页内容旨在传播知识，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com