<table width="100%" border="1" cellspacing="0" cellpadding="0" bgcolor = "#61FF13">
<TR style="text-align : center;">
<TD>单元格A</TD>
<TD>单元格A</TD>
<TD>单元格A</TD>
<TD>单元格A</TD>
</TR>
<TR>
<TD colSpan=4 style="text-align : center;"><font color="BLUE" face="Verdana">单元格合并行A</FONT></TD>
</TR>
</TABLE>
<BR>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<TR style="text-align : center;">
<TD>单元格B</TD>
<TD>单元格B</TD>
<TD>单元格B</TD>
<TD>单元格B</TD>
</TR>
<TR>
<TD colSpan=4 style="text-align : center;">单元格合并行B</TD>
</TR>
</TABLE>
<br><br><br>
<input type="button" onclick="javascript:AllAreaExcel();" value="导出页面内容到Excel">
<SCRIPT LANGUAGE="javascript">
function AllAreaExcel()
{
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
for(i = 0;i<document.getElementsByTagName("TABLE").length;i++)
{
oSheet = oWB.Worksheets.Add();
sel=document.body.createTextRange();
sel.moveToElementText(document.getElementsByTagName("TABLE")[i]);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
}
oXL.Visible = true;
}
</SCRIPT>
</body>
</html>
<TR style="text-align : center;">
<TD>单元格A</TD>
<TD>单元格A</TD>
<TD>单元格A</TD>
<TD>单元格A</TD>
</TR>
<TR>
<TD colSpan=4 style="text-align : center;"><font color="BLUE" face="Verdana">单元格合并行A</FONT></TD>
</TR>
</TABLE>
<BR>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<TR style="text-align : center;">
<TD>单元格B</TD>
<TD>单元格B</TD>
<TD>单元格B</TD>
<TD>单元格B</TD>
</TR>
<TR>
<TD colSpan=4 style="text-align : center;">单元格合并行B</TD>
</TR>
</TABLE>
<br><br><br>
<input type="button" onclick="javascript:AllAreaExcel();" value="导出页面内容到Excel">
<SCRIPT LANGUAGE="javascript">
function AllAreaExcel()
{
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
for(i = 0;i<document.getElementsByTagName("TABLE").length;i++)
{
oSheet = oWB.Worksheets.Add();
sel=document.body.createTextRange();
sel.moveToElementText(document.getElementsByTagName("TABLE")[i]);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
}
oXL.Visible = true;
}
</SCRIPT>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货