如何将html页面导出到excel,html页面表格导出到excel总结(示例代码)

html 表格导出道Excel
列标题1	列标题2	类标题3	列标题4	列标题5
aaa	bbb	ccc	ddd	eee
AAA	BBB	CCC	DDD	EEE
FFF	GGG	HHH	III	JJJ

1、js的方法

A、将整个表格拷贝到EXCEL中

function method1(tableid) {

var curTbl = document.getElementById(tableid);

var oXL = new ActiveXObject("Excel.Application");

var oWB = oXL.Workbooks.Add();

var oSheet = oWB.ActiveSheet;

var sel = document.body.createTextRange();

sel.moveToElementText(curTbl);

sel.select();

sel.execCommand("Copy");

oSheet.Paste();

oXL.Visible = true;

}

B、读取表格中每个单元到EXCEL中：

function method2(tableid)

{

var curTbl = document.getElementById(tableid);

var oXL = new ActiveXObject("Excel.Application");

var oWB = oXL.Workbooks.Add();

var oSheet = oWB.ActiveSheet;

var Lenr = curTbl.rows.length;

for (i = 0; i < Lenr; i++)

{

var Lenc = curTbl.rows(i).cells.length;

for (j = 0; j < Lenc; j++)

{

oSheet.Cells(i + 1, j