javaScript 导出excel
1.效果图，IE浏览器安全启用 “ 对没有标记为安全的ActiveX控件进行初始化和脚本运行”
Code<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!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 runat="server">
<title>流程监控报表结果页面</title>
<script language="javascript" type="text/javascript">
function excel()
{
var oXL = new ActiveXObject("Excel.Application");
oXL.Visible = true;
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
for (i=0; i < document.all.report.rows.length; i++)
{
for (j=0; j < document.all.report.rows(i).cells.length; j++)
{
oSheet.Cells(i+1,j+1).Value = document.all.report.rows(i).cells(j).innerText;
}
oXL.Visible = true;
oXL.UserControl = true;
}
}
</script>
</head>
<INPUT type ="button" onclick="excel()" value="导出到Excel">
<TABLE id=report border="1" cellspacing="0" bordercolorlight="#C0C0C0" bordercolor="#000080" bordercolordark="#FFFFFF">
<TR>
<TD height="31" bgcolor="#008080"><b><FONT color="#FFFFFF">承担用户</FONT></B></TD>
<TD height="31" bgcolor="#008080"> <b><FONT color="#FFFFFF">接收时间</FONT></B></TD>
<TD height="31" bgcolor="#008080"> <b><FONT color="#FFFFFF">任务名称</FONT></B></TD>
<TD height="31" bgcolor="#008080"> <b><FONT color="#FFFFFF">进程名称</FONT></B></TD>
<TD height="31" bgcolor="#008080"> <b><FONT color="#FFFFFF">滞留天数</FONT></B></TD>
</TR>
<TR>
<TD bgcolor="#E7E7E7">Administrators</TD>
<TD bgcolor="#E7E7E7"> </TD>
<TD bgcolor="#E7E7E7"> </TD>
<TD bgcolor="#E7E7E7"> </TD>
<TD bgcolor="#E7E7E7"> </TD>
</TR>
<TR>
<TD><FONT size="2">Administrator</FONT></TD>
<TD><FONT size="2">2006-08-25</FONT></TD>
<TD><FONT size="2">Submit</FONT></TD>
<TD><FONT size="2">Submit_PART1 (part1) A</FONT></TD>
<TD><FONT size="2">3</FONT></TD>
</TR>
<TR>
<TD><FONT size="2">Administrator</FONT></TD>
<TD><FONT size="2">2006-08-28</FONT></TD>
<TD><FONT size="2">提交变更申请单</FONT></TD>
<TD><FONT size="2">变更申请单审批流程007_00021 (03201-jz-22)</FONT></TD>
<TD><FONT size="2">0</FONT></TD>
</TR>
</TABLE>
<BR>
</BODY>
</html>
浙公网安备 33010602011771号