足球游戏_中国足彩网¥体育资讯$

asp.net+Ligerui实现grid导出Excel和Word的方法
来源:易贤网 阅读:1060 次 日期:2016-08-09 16:14:48
温馨提示:易贤网小编为您整理了“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" />

  <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程序设计有所帮助。

中国足彩网信息请查看网络编程
由于各方面情况的不断调整与变化,易贤网提供的所有考试信息和咨询回复仅供参考,敬请考生以权威部门公布的正式信息和咨询为准!

2025国考·省考课程试听报名

  • 报班类型
  • 姓名
  • 手机号
  • 验证码
关于我们 | 联系我们 | 人才招聘 | 网站声明 | 网站帮助 | 非正式的简要咨询 | 简要咨询须知 | 加入群交流 | 手机站点 | 投诉建议
工业和信息化部备案号:滇ICP备2023014141号-1 足球游戏_中国足彩网¥体育资讯$ 滇公网安备53010202001879号 人力资源服务许可证:(云)人服证字(2023)第0102001523号
云南网警备案专用图标
联系电话:0871-65099533/13759567129 获取招聘考试信息及咨询关注公众号:hfpxwx
咨询QQ:526150442(9:00—18:00)版权所有:易贤网
云南网警报警专用图标