在aspx页面中使用就出现:
automation服务器不能创建对象!
不知道为什么!
在htm页中能够正常使用!<%@ Page language="c#" Codebehind="WebForm2.aspx.cs" AutoEventWireup="false" Inherits="Askdb.BEI.WebApp.EBICollate.excel.WebForm2" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm2</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<TABLE id="PrintA" style="Z-INDEX: 101; LEFT: 8px; POSITION: absolute; TOP: 8px" cellSpacing="0"
cellPadding="0" width="100%" bgColor="#61ff13" border="1">
<TR style="TEXT-ALIGN: center">
<TD>单元格A</TD>
<TD>单元格A</TD>
<TD>单元格A</TD>
<TD>单元格A</TD>
</TR>
<TR>
<TD colSpan="4"><FONT face="Verdana" color="blue">单元格合并行A</FONT></TD>
</TR>
</TABLE>
<INPUT onclick="javascript:CellAreaExcel();" style="Z-INDEX: 103; LEFT: 96px; POSITION: absolute; TOP: 64px"
type="button" value="Button2"> <INPUT onclick="javascript:AutomateExcel();" style="Z-INDEX: 104; LEFT: 176px; POSITION: absolute; TOP: 64px"
type="button" value="Button3">
</form>
<SCRIPT LANGUAGE="javascript">
             //指定页面区域内容导入Excel
             function AllAreaExcel() 
             {
              var oXL = new ActiveXObject("Excel.Application"); 
              var oWB = oXL.Workbooks.Add(); 
              var oSheet = oWB.ActiveSheet;  
              var sel=document.body.createTextRange();
              sel.moveToElementText(PrintA);
              sel.select();
              sel.execCommand("Copy");
              oSheet.Paste();
              oXL.Visible = true;
             }
             //指定页面区域“单元格”内容导入Excel
             function CellAreaExcel() 
             {
              var oXL = new ActiveXObject("Excel.Application"); 
              var oWB = oXL.Workbooks.Add(); 
              var oSheet = oWB.ActiveSheet; 
              var Lenr = PrintA.rows.length;
              for (i=0;i<Lenr;i++) 
              { 
               var Lenc = PrintA.rows(i).cells.length; 
               for (j=0;j<Lenc;j++) 
               { 
                oSheet.Cells(i+1,j+1).value = PrintA.rows(i).cells(j).innerText;                } 
              } 
              oXL.Visible = true; 
             }
             function AutomateExcel()
             {
// Start Excel and get Application object.
var oXL = new ActiveXObject("Excel.Application");
// Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var table = document.all.PrintA;
var hang = table.rows.length; var lie = table.rows(0).cells.length; // Add table headers going cell by cell.
for (i=0;i<hang;i++)
{
for (j=0;j<lie;j++)
{
oSheet.Cells(i+1,j+1).value = table.rows(i).cells(j).innerText;
} }
oXL.Visible = true;
oXL.UserControl = true;
}
</SCRIPT>
</FONT>
</body>
</HTML>