下次自动登录
现在的位置:
& 综合 & 正文
ligerUI导出excel
首先是在线测试例子:
ligerui是基于jquery来搭建页面，一个grid控件本质上是几个table组合而成
如果可以将这个DOM的架构直接传回后台，自然可以输出为excel或者word或者pdf
为何不在前台Js实现html导出为excel，因为js来创建excel这玩意会碰到浏览器安全性问题，不实用
这个也贴一个方法，一个js搞定
[javascript]
function method1() {
if(navigator.userAgent.indexOf("MSIE")&0){
alert('请用ie浏览器进行表格导出');
var tableid="maingrid";
var curTbl = document.getElementById(tableid);
var oXL = null;
oXL = GetObject("", "Excel.Application");
catch (E) {
oXL = new ActiveXObject("Excel.Application");
catch (E2) {
alert("Please confirm:\n1.Microsoft Excel has been installed.\n2.Internet Options=&Security=&Setting \"Enable unsafe ActiveX\"");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveS
oSheet.Rows(1+":"+1).RowHeight =20;
oSheet.Rows(2+":"+2).RowHeight =30;
oSheet.Rows(1).HorizontalAlignment=3;
var sel = document.body.createTextRange();
sel.moveToElementText(curTbl);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
oSheet.Application.Quit();
window.opener=null;
window.close();
function method1() {//整个表格拷贝到EXCEL中
//检索浏览器
if(navigator.userAgent.indexOf("MSIE")&0){
alert('请用ie浏览器进行表格导出');
var tableid="maingrid";
var curTbl = document.getElementById(tableid);
oXL = GetObject("", "Excel.Application");
catch (E) {
oXL = new ActiveXObject("Excel.Application");
catch (E2) {
alert("Please confirm:\n1.Microsoft Excel has been
installed.\n2.Internet Options=&Security=&Setting \"Enable unsafe
ActiveX\"");
//创建AX对象excel
var oWB = oXL.Workbooks.Add();
//获取workbook对象
var oSheet = oWB.ActiveS
//在此进行样式控制
oSheet.Rows(1+":"+1).RowHeight =20;//定义行高
oSheet.Rows(2+":"+2).RowHeight =30;
oSheet.Rows(1).HorizontalAlignment=3;
var sel = document.body.createTextRange(); //激活当前sheet
sel.moveToElementText(curTbl); //把表格中的内容移到TextRange中
sel.select();
//全选TextRange中内容
sel.execCommand("Copy"); //复制TextRange中内容
oSheet.Paste(); //粘贴到活动的EXCEL中
oXL.Visible = //设置excel可见属性
oSheet.Application.Quit();
//结束当前进程
window.opener=
window.close();//关闭当前窗口
} (这个方法，只可IE并且要允许不安全的activex运行，这也太危险了，这年头...)
下面采用的导EXCEL方法，适合不翻页的grid，而且无需再读一次数据库，
对于翻页的grid来说，要导全部，当然后台要再读一次数据库，这种导EXCEL方法baidu一大堆，这里不重复
&!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
xmlns="http://www.w3.org/1999/xhtml"
href="../lib/ligerUI/skins/Aqua/css/ligerui-all.css" rel="stylesheet" type="text/css"
href="../lib/ligerUI/skins/ligerui-icons.css" rel="stylesheet" type="text/css"
src="../lib/jquery/jquery-1.3.2.min.js" type="text/javascript"
src="../lib/ligerUI/js/plugins/ligerGrid.js" type="text/javascript"
src="../lib/ligerUI/js/plugins/ligerToolBar.js" type="text/javascript"
src="../lib/ligerUI/js/plugins/ligerDialog.js" type="text/javascript"
src="AllProductData.js" type="text/javascript"
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 '最大值:' + suminf.max + '';},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.UnitsInStockT
function itemclick(item)
grid = $("#maingrid").ligerGetGridManager();
if(item.id)
switch (item.id)
case "excel":$.ligerDialog.open({url: "../service/print.aspx?exporttype=xls"});
case "word":$.ligerDialog.open({url: "../service/print.aspx?exporttype=doc"});
style="padding:0 overflow: height:100%
id="toptoolbar"
id="maingrid" style="margin:0; padding:0"
style="display:"
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" &
&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: [
'导出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:
{ 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.UnitsInStockT
function itemclick(item)
grid = $("#maingrid").ligerGetGridManager();
if(item.id)
switch (item.id)
case "excel":$.ligerDialog.open({url:
"../service/print.aspx?exporttype=xls"});
case "word":$.ligerDialog.open({url:
"../service/print.aspx?exporttype=doc"});
&body style="padding:0 overflow: height:100%
&div id="toptoolbar"&&/div&
&div id="maingrid" style="margin:0; padding:0"&&/div&
&div style="display:"&&/div&
导出页面print.aspx
%@ Page Language="C#" AutoEventWireup="true" CodeBehind="print.aspx.cs" Inherits="example" EnableEventValidation = "false" ValidateRequest="false" %
href="../lib/ligerUI/skins/aqua/css/ligerui-all.css" rel="stylesheet" type="text/css"
src="../lib/jquery/jquery-1.3.2.min.js" type="text/javascript"
src="../lib/ligerUI1.1.0/js/ligerui.min.js" type="text/javascript"
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]);
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()+""+ //这是全局汇总，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();
document.getElementById("btndoc").click();
setTimeout(function ()
parent.$.ligerDialog.close();
style="padding:20px" onload="init()"
id="form1" runat="server"
style="visibility:hidden"
ID="btnxls" runat="server" Text="导出Excel" onclick="Button1_Click" OnClientClick="gethtml('#maingrid')"
ID="btndoc" runat="server" Text="导出Word"
onclick="Button2_Click" OnClientClick="gethtml('#maingrid')"
ID="hf" runat="server"
Page Language="C#" AutoEventWireup="true" CodeBehind="print.aspx.cs"
Inherits="example" EnableEventValidation = "false"
ValidateRequest="false" %&
&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]);
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();
document.getElementById("btndoc").click();
setTimeout(function ()
parent.$.ligerDialog.close();
&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')"/&
&asp:HiddenField ID="hf" runat="server" /&
print.aspx.cs
using System.C
using System.C
using System.D
using System.W
using System.Web.S
using System.Web.UI;
using System.Web.UI.HtmlC
using System.Web.UI.WebC
using System.Web.UI.WebControls.WebP
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", "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", "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();
using System.C
using System.C
using System.D
using System.W
using System.Web.S
using System.Web.UI;
using System.Web.UI.HtmlC
using System.Web.UI.WebC
using System.Web.UI.WebControls.WebP
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 =
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "filename=tmp.xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/ms-excel";
this.EnableViewState =
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 =
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "filename=tmp.doc");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/ms-word";
this.EnableViewState =
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
&&&&推荐文章:
【上篇】【下篇】ChipLogic Analyzer快捷键及图标一览表_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
ChipLogic Analyzer快捷键及图标一览表
上传于||文档简介
&&微​电​子​ ​,​提​图​软​件
阅读已结束，如果下载本文需要使用1下载券
想免费下载本文？
下载文档到电脑，查找使用更方便
还剩3页未读，继续阅读
你可能喜欢项目中用了Excel做报表打印，效果还不错。但也遇到了一个不爽的事就是EXCEL进程打开预先做好的模板，生成报表，并且把结果发到客户端之后，会在其中的一台服务器上的C盘根目录生成好些文件以及目录的链接，让人看着很不爽。但是程序在其他的5~6台机子上跑都没有发现这种情况。经过查找资料和观察，发现office软件在操作文件时会访问三个目录分别是：
1.Recent目录生成文档的快捷方式。（就是开始菜单中的文档）
2.系统所在目录"Documents and Settings"当前登录用户"Application Data"Microsoft"Office"Recent&生成文件与目录的快捷方式
3.系统所在目录"Documents and Settings"Default User"Application Data"Microsoft"Office"Recent（有的机子会用到）
检查相应2或者3 目录是否存在，如果不存在就手动创建目录。创建此目录后excel进程就不会再根目录生成快捷方式了。
令人费解的是没出问题的服务器没有3目录，也不会在根目录生成快捷方式。但是出问题的那台服务器，如果没有3目录就会在根目录生成快捷方式。有问题与没问题的服务器都是win 2003 server 企业版，也都装有office 2007.其它配置也几乎一致。但是偏偏有台就出现上述的问题，真是令人费解！
阅读(...) 评论() &