当前位置：Gxlcms > asp.net > asp.net+Ligerui实现grid导出Excel和Word的方法

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

时间：2021-07-01 10:21:17 帮助过：7人阅读

本文实例讲述了asp.net+Ligerui实现grid导出Excel和Word的方法。分享给大家供大家参考，具体如下：

下面采用的导EXCEL方法，适合不翻页的grid，而且无需再读一次数据库，对于翻页的grid来说，要导全部，当然后台要再读一次数据库，这种导EXCEL方法baidu一大堆，这里不重复

代码部分:

grid.htm：

  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  2. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml" >
  4. <head>
  5.   <title></title>
  6.   <link href="../lib/ligerUI/skins/Aqua/css/ligerui-all.css" rel="stylesheet" type="text/css" />
  7.   <link href="../lib/ligerUI/skins/ligerui-icons.css" rel="stylesheet" type="text/css" />
  8.   <script src="../lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
  9.   <script src="../lib/ligerUI/js/plugins/ligerGrid.js" type="text/javascript"></script>
  10.   <script src="../lib/ligerUI/js/plugins/ligerToolBar.js" type="text/javascript"></script>
  11.   <script src="../lib/ligerUI/js/plugins/ligerDialog.js" type="text/javascript"></script>
  12.   <script src="AllProductData.js" type="text/javascript"></script>
  13.   <script type="text/javascript">
  14.     $(function () {
  15.       $("#toptoolbar").ligerToolBar({ items: [
  16.             {text: '导出Excel',id:'excel',icon:'print',click:itemclick},
  17.             {text: '导出Word' ,id:'word',icon:'print',click:itemclick}
  18.           ]
  19.       });
  20.       $("#maingrid").ligerGrid({
  21.         columns: [
  22.           { display: '主键', name: 'ProductID', type: 'int', totalSummary:{type: 'count'}},
  23.           { display: '产品名', name: 'ProductName', align: 'left', width: 200 },
  24.           { display: '单价', name: 'UnitPrice', align: 'right', type:'float',totalSummary:{render: function (suminf, column, cell){return '<div>最大值:' + suminf.max + '</div>';},align: 'left'}},
  25.           { display: '仓库数量', name: 'UnitsInStock', align: 'right', type: 'float',totalSummary:{type: 'sum'}}
  26.         ],
  27.         dataAction: 'local',
  28.         data: AllProductData, sortName: 'ProductID',
  29.         showTitle: false, totalRender: f_totalRender,
  30.         width: '100%', height: '100%',heightDiff:-10
  31.       });
  32.       $("#pageloading").hide();
  33.     });
  34.     function f_totalRender(data, currentPageData)
  35.     {
  36.       return "总仓库数量:"+data.UnitsInStockTotal;
  37.     }
  38.     function itemclick(item)
  39.     {
  40.       grid = $("#maingrid").ligerGetGridManager();
  41.       if(item.id)
  42.       {
  43.         switch (item.id)
  44.         {
  45.           case "excel":$.ligerDialog.open({url: "../service/print.aspx?exporttype=xls"});return;
  46.           case "word":$.ligerDialog.open({url: "../service/print.aspx?exporttype=doc"});return;
  47.         }
  48.       }
  49.     }
  50.   </script>
  51. </head>
  52. <body style="padding:0px; overflow:hidden; height:100% ">
  53.   <div id="toptoolbar"></div>
  54.   <div id="maingrid" style="margin:0; padding:0"></div>
  55.   <div style="display:none;"></div>
  56. </body>
  57. </html>

导出页面print.aspx

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="print.aspx.cs" Inherits="example" EnableEventValidation = "false" ValidateRequest="false" %>
  2. <html>
  3. <head>
  4.   <title></title>
  5.   <link href="../lib/ligerUI/skins/aqua/css/ligerui-all.css" rel="stylesheet" type="text/css" />
  6.   <script src="../lib/jquery/jquery-1.3.2.min.js" type="text/javascript"></script>
  7.   <script src="../lib/ligerUI1.1.0/js/ligerui.min.js" type="text/javascript"></script>
  8.   <script type="text/javascript">
  9.     function GetQueryString(name)
  10.     {
  11.       var reg = new RegExp("(^|&)"+name+"=([^&]*)(&|$)");
  12.       var r= window.location.search.substr(1).match(reg);
  13.       if (r!=null) return unescape(r[2]);return null;
  14.     }
  15.     function gethtml(g)
  16.     {
  17.       parent.$(".l-grid-header-table",g).attr("border","1");
  18.       parent.$(".l-grid-body-table",g).attr("border","1");
  19.       $("#hf").val(
  20.             parent.$(".l-grid-header",g).html()+       //这里把表头捞出来
  21.             parent.$(".l-grid-body-inner",g).html()+     //表身，具体数据
  22.             parent.$(".l-panel-bar-total",g).html()+"<br/>"+ //这是全局汇总，1.1.0版本新添加的
  23.             parent.$(".l-bar-text",g).html()         //这是翻页讯息
  24.             );
  25.       parent.$(".l-grid-header-table",g).attr("border","0");
  26.       parent.$(".l-grid-body-table",g).attr("border","0");
  27.      // parent.$(".l-grid-header-table",g).removeAttr("border");
  28.      // parent.$(".l-grid-body-table",g).removeAttr("border");
  29.     }
  30.     function init()
  31.     {
  32.       if (GetQueryString("exporttype")=="xls")
  33.       {
  34.         document.getElementById("btnxls").click();
  35.       }
  36.       else
  37.       {
  38.         document.getElementById("btndoc").click();
  39.       }
  40.       setTimeout(function ()
  41.       {
  42.         parent.$.ligerDialog.close();
  43.       }, 3000);
  44.     }
  45.   </script>
  46. </head>
  47. <body style="padding:20px" onload="init()">
  48.   <form id="form1" runat="server">
  49.   导出中...
  50.   <div style="visibility:hidden">
  51.   <asp:Button ID="btnxls" runat="server" Text="导出Excel" onclick="Button1_Click" OnClientClick="gethtml('#maingrid')"/>
  52.   <asp:Button ID="btndoc" runat="server" Text="导出Word" onclick="Button2_Click" OnClientClick="gethtml('#maingrid')"/>
  53.   </div>
  54.   <asp:HiddenField ID="hf" runat="server" />
  55.   </form>
  56. </body>
  57. </html>

print.aspx.cs

  1. using System;
  2. using System.Collections;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.HtmlControls;
  9. using System.Web.UI.WebControls;
  10. using System.Web.UI.WebControls.WebParts;
  11. namespace service
  12. {
  13.   public partial class print : System.Web.UI.Page
  14.   {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.       if (!IsPostBack)
  18.       {
  19.       }
  20.     }
  21.     void exportexcel()
  22.     {
  23.       Response.Clear();
  24.       Response.Buffer = true;
  25.       Response.Charset = "utf-8";
  26.       Response.AppendHeader("Content-Disposition", "attachment;filename=tmp.xls");
  27.       Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
  28.       Response.ContentType = "application/ms-excel";
  29.       this.EnableViewState = false;
  30.       System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
  31.       System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
  32.       oHtmlTextWriter.WriteLine(hf.Value);
  33.       Response.Write(oStringWriter.ToString());
  34.       Response.End();
  35.     }
  36.     void exportword()
  37.     {
  38.       Response.Clear();
  39.       Response.Buffer = true;
  40.       Response.Charset = "utf-8";
  41.       Response.AppendHeader("Content-Disposition", "attachment;filename=tmp.doc");
  42.       Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
  43.       Response.ContentType = "application/ms-word";
  44.       this.EnableViewState = false;
  45.       System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
  46.       System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
  47.       oHtmlTextWriter.WriteLine(hf.Value);
  48.       Response.Write(oStringWriter.ToString());
  49.       Response.End();
  50.     }
  51.     protected void Button1_Click(object sender, EventArgs e)
  52.     {
  53.       exportexcel();
  54.     }
  55.     protected void Button2_Click(object sender, EventArgs e)
  56.     {
  57.       exportword();
  58.     }
  59.   }
  60. }

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

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

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

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！