javascript 导出html table到 excel(转载)
function toExcel(tablename) //导出到excel
{
var mysheet=new ActiveXObject("OWC.Spreadsheet");
with(mysheet)
{
DataType = "HTMLData";
HTMLData =tablename.outerHTML;
try
{
ActiveSheet.Cells(1,1).value="";
ActiveSheet.Cells(2,1).value="";
// ActiveSheet.Cells(34,1).value="导出完毕";
ActiveSheet.Export("导出.xls", 0);
alert('导出完毕');
};
catch (e)
{
alert('导出Excel表失败,请确定已安装Excel2000(或更高版本),并且没打开同名xls文件');
};
}
}
function toExcel(tablename) //导出到excel
{
var mysheet=new ActiveXObject("OWC.Spreadsheet");
with(mysheet)
{
DataType = "HTMLData";
HTMLData =tablename.outerHTML;
try
{
ActiveSheet.Cells(1,1).value="";
ActiveSheet.Cells(2,1).value="";
// ActiveSheet.Cells(34,1).value="导出完毕";
ActiveSheet.Export("导出.xls", 0);
alert('导出完毕');
};
catch (e)
{
alert('导出Excel表失败,请确定已安装Excel2000(或更高版本),并且没打开同名xls文件');
};
}
}