<script>
function PrintExcel()
{
if(window.confirm("此功能需要客户端安装Microsoft Office组件,并需要降低IE浏览器的安全性,您真的要继续吗?"))
{
var oXL = new ActiveXObject("Excel.Application");
oXL.Visible = true; // Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet; // Add table headers going cell by cell.
omxh = document.getElementById("mxh")
oSheet.Cells(1,1).Value = "ddddd";
for(i=1;i<omxh.rows[0].cells.length;i++)
{
oSheet.Cells(2, i).Value = omxh.rows[0].cells[i].innerText;
} // Format A1:D1 as bold, vertical alignment = center.
oSheet.Range("A1", "AA2").Font.Bold = true;
for(i=1;i<omxh.rows.length;i++)
{ for(j=1;j<omxh.rows[i].cells.length;j++)
{
oSheet.Cells(i+2, j).Value = omxh.rows[i].cells[j].innerText;
}
oSheet.Cells(i+2, 2).NumberFormat = "@";
//oSheet.Rows("2:2").Select()
//Selection.NumberFormatLocal = "@"
}
}
}</script><table id=mxh>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
</table>
<input type=button value=PrintToExcel onclick="PrintExcel()">
function PrintExcel()
{
if(window.confirm("此功能需要客户端安装Microsoft Office组件,并需要降低IE浏览器的安全性,您真的要继续吗?"))
{
var oXL = new ActiveXObject("Excel.Application");
oXL.Visible = true; // Get a new workbook.
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet; // Add table headers going cell by cell.
omxh = document.getElementById("mxh")
oSheet.Cells(1,1).Value = "ddddd";
for(i=1;i<omxh.rows[0].cells.length;i++)
{
oSheet.Cells(2, i).Value = omxh.rows[0].cells[i].innerText;
} // Format A1:D1 as bold, vertical alignment = center.
oSheet.Range("A1", "AA2").Font.Bold = true;
for(i=1;i<omxh.rows.length;i++)
{ for(j=1;j<omxh.rows[i].cells.length;j++)
{
oSheet.Cells(i+2, j).Value = omxh.rows[i].cells[j].innerText;
}
oSheet.Cells(i+2, 2).NumberFormat = "@";
//oSheet.Rows("2:2").Select()
//Selection.NumberFormatLocal = "@"
}
}
}</script><table id=mxh>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
<tr><td>aaa</td><td>aaa</td><td>aaa</td><td>aaa</td></tr>
</table>
<input type=button value=PrintToExcel onclick="PrintExcel()">
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货