81,091
社区成员
发帖
与我相关
我的任务
分享
function AutomateExcelall()
{
var i,j;
// Start Excel and get Application object.
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.
var tblout = document.getElementById("tblout");
for(i=1;i<tblout.rows.length;i++)
{
for(j=1;j<tblout.rows(i).cells.length;j++)
{
oSheet.Cells(i+1, j).Value = tblout.rows(i).cells(j).innerText;
}
}
oXL.Visible = true;
oXL.UserControl = true;
}