//table内容-->paste-->excel

function tablepaste2excel(strexcel,irow,icol) {
	var ExcelApp;
	var ExcelBook;
	ExcelApp = new ActiveXObject("Excel.Application");

	ExcelBook = ExcelApp.Workbooks.Add();

	var strexcel=document.all.table1.outerHTML;
	window.clipboardData.setData("Text",strexcel);

	ExcelBook.Worksheets(1).Range("A1").Select;

	ExcelBook.Worksheets(1).paste;

	ExcelApp.Application.Visible = true;
	idTmr = window.setInterval("Cleanup();",1000)

}


//防Excel死进程

function Cleanup() {
	window.clearInterval(idTmr);
	CollectGarbage();
}


//多行格式字符串-->excel
//var strexcel="商户编号，商户名称，姓名，性别，身份证号码，电话\n";
//strexcel=strexcel+"0001,商户1,张飞,男,110109,010\n";
//strexcel=strexcel+"0002,商户1,关羽,男,110105,010\n";
//strexcel=strexcel+"0003,商户2,刘备,男,110101,010\n";

function excel(strexcel,irow,icol) {
	var ExcelApp;
	var ExcelBook;
	ExcelApp = new ActiveXObject("Excel.Application");

	ExcelBook = ExcelApp.Workbooks.Add();

	ExcelBook.Worksheets(1).Columns("E:E").Select;
	ExcelApp.Selection.NumberFormatLocal = "@";
	ExcelBook.Worksheets(1).Columns("E:E").ColumnWidth = 22;
	ExcelBook.Worksheets(1).Range("C6").Select;

	lines=strexcel.split('\n');
	for (i=0;i<lines.length;i++) {
		colstr=lines[i].split(",");
		icol=1;
		for (j=0; j<colstr.length; j++) {
			ExcelBook.Worksheets(1).Cells(irow,icol).value=colstr[j];
			icol++;
		}
		irow++;
	}

	ExcelApp.Application.Visible = true;
	idTmr = window.setInterval("Cleanup();",1000)

}


function tableToExcel(tablename) { //整体导出；不需要table id
	window.clipboardData.setData("Text",document.all(tablename).outerHTML);
	try
	{
		var ExApp = new ActiveXObject("Excel.Application")
		var ExWBk = ExApp.workbooks.add()
		var ExWSh = ExWBk.worksheets(1)
		ExApp.DisplayAlerts = false
		ExApp.visible = true
	 }
	 catch(e)
	{
		alert(e);
		alert("您的电脑没有安装 Excel软件")
		return false
	 }
	ExWBk.worksheets(1).Paste; 
}


function createstr(objtablename) { //table --> 多行格式数据字符串，需要table id,不需要行id
	var str1="";
	var linestr="";
	if (objtablename) {
		for (var i=0; i<objtablename.rows.length; i++) {
			linestr="";
			for (var j=0; j<objtablename.rows[i].cells.length; j++) {
				linestr+=objtablename.rows[i].cells[j].innerText+",";
			}
			str1=str1+linestr+'\n';
		}
	}
	alert(str1);
	return str1;
}


//单元格式格式字符串-->excel
// row,col,value\n

function excell(strexcel) {
	var irow,icol;
	var ExcelApp;
	var ExcelBook;
	ExcelApp = new ActiveXObject("Excel.Application");

	ExcelBook = ExcelApp.Workbooks.Add();

	lines=strexcel.split('\n');
	for (i=0;i<lines.length;i++) {
		colstr=lines[i].split(",");
		irow=parseInt(colstr[0]);
		icol=parseInt(colstr[1]);
		ExcelBook.Worksheets(1).Cells(irow,icol).value=colstr[2];
	}

	ExcelApp.Application.Visible = true;
	idTmr = window.setInterval("Cleanup();",1000)

}