日期:2014-05-16  浏览次数:20363 次

javaScript将页面的表格导成EXCEL(按单元格)

JS部份:

//自定定义一个用于记录导出信息的对像
function TableToExcel(tableID) {
	 	this.tableBorder = -1; //边框类型,-1没有边框 可取1/2/3/4
	 	this.backGround = 0; //背景颜色:白色 可取调色板中的颜色编号 1/2/3/4....
	 	this.fontColor = 1; //字体颜色:黑色
	 	this.fontSize = 10; //字体大小
	 	this.fontStyle = "宋体"; //字体类型
	 	this.rowHeight = 20; //行高
	 	this.columnWidth = -1; //列宽
	 	this.lineWrap = true; //是否自动换行
	 	this.textAlign = -4108; //内容对齐方式 默认为居中
	 	this.autoFit = true; //是否自适应宽度
	 	this.tableID = tableID; 
}

TableToExcel.prototype.setTableBorder = function (excelBorder) {
	this.tableBorder = excelBorder ;
};
 
TableToExcel.prototype.setBackGround = function (excelColor) {
	this.backGround = excelColor;
};
 
TableToExcel.prototype.setFontColor = function (excelColor) {
	this.fontColor = excelColor;
};
 
TableToExcel.prototype.setFontSize = function (excelFontSize) {
	this.fontSize = excelFontSize;
}; 

TableToExcel.prototype.setFontStyle = function (excelFont) {
	this.fontStyle = excelFont;
};

TableToExcel.prototype.setRowHeight = function (excelRowHeight) {
	this.rowHeight = excelRowHeight;
};

TableToExcel.prototype.setColumnWidth = function (excelColumnWidth) {
	this.columnWidth = excelColumnWidth;
};

TableToExcel.prototype.isLineWrap = function (lineWrap) {
	if (lineWrap == false || lineWrap == true) {
		this.lineWrap = lineWrap;
	}
};

TableToExcel.prototype.setTextAlign = function (textAlign) {
	this.textAlign = textAlign;
};

TableToExcel.prototype.isAutoFit = function(autoFit){
	if(autoFit == true || autoFit == false)this.autoFit = autoFit ;
};

//文件转换主函数
TableToExcel.prototype.getExcelFile = function () {
	//先声明Excel插件、Excel工作簿等对像
	var jXls, myWorkbook, myWorksheet, myHTMLTableCell, myExcelCell, myExcelCell2;
	var myCellColSpan, myCellRowSpan; 
	try {
		jXls = new ActiveXObject('Excel.Application');//插件初始化失败时作出提示
	}catch (e) {
		alert("无法启动Excel!\n\n如果您确信您的电脑中已经安装了Excel,"+"那么请调整IE的安全级别。\n\n具体操作:\n\n"+"工具 → Internet选项 → 安全 → 自定义级别 → 对没有标记为安全的ActiveX进行初始化和脚本运行 → 启用");
		return false;
	}
	//jXls.Visible = true;//这句写在这里可以看见整个EXCEL文档的加载过程
	jXls.DisplayAlerts = false;//不显示警告	
	
	myWorkbook = jXls.Workbooks.Add();//新建EXCEL文件
	myWorkbook.Worksheets(3).Delete();//删除第3个标签页
	myWorkbook.Worksheets(2).Delete();//删除第2个标签页
	
	myWorksheet = myWorkbook.ActiveSheet; //获取当前活动的标签页
	
	var readRow = 0, readCol = 0;
	var totalRow = 0, totalCol = 0;
	var tabNum = 0; 
	//设置列宽
	if(this.columnWidth != -1)
		myWorksheet.Columns.ColumnWidth = this.columnWidth;
	else
		myWorksheet.Columns.ColumnWidth = 7;
		
	//设置行高
	if(this.rowHeight != -1)
		myWorksheet.Rows.RowHeight = this.rowHeight ; 
		
	//搜索需要转换的Table对象,获取对应行、列数
	var obj = document.all.tags("table");
	for (var x = 0; x < obj.length; x++) {
		if (obj[x].id == this.tableID) {
			tabNum = x;
			totalRow = obj[x].rows.length;//记录总行数
			
			//根据第一行的单元格数及各个单元格合并的格数来计算总列数
			for (var i = 0; i < obj[x].rows[0].cells.length; i++) {
				myHTMLTableCell = obj[x].rows[0].cells(i);
				myCellColSpan = myHTMLTableCell.colSpan;
				totalCol = totalCol + myCellColSpan;
			}
		}
	}
	
	//开始根据总行数、总列数构件模拟表格
	var excelTable = new Array();
	for (var i = 0; i <= totalRow; i++) {
		excelTable[i] = new Array();
		for (var t = 0; t <= totalCol; t++) {
			excelTable[i][t] = false;
		}
	}
	 
	//开始转换表格 
	for (var z = 0; z < obj[tabNum].rows.length; z++) {
		readRow = z + 1;
		readCol = 0;
		for (var c = 0; c < obj[tabNum].rows(z).cells.length; c++) {
			myHTMLTableCell = obj[tabNum].rows(z).cells(c);//获取HTML表格单元格对像
			myCellColSpan = myHTMLTableCell.colSpan;//获取单元格合并列数
			myCellRowSpan = myHTMLTableCell.rowSpan;//获取单元格合并行数
			for (var y = 1; y <= totalCol; y++) {
				if (excelTable[readRow][y] == false) {
					readCol = y;
					break;
				}
			}
			//合并行数*合并列数>0说明这一格有合并
			if (myCellColSpan * myCellRowSpan > 1) {
				myExcelCell = myWorksheet.Cells(readRow, readCol);//定位单元格的起始格
				myExcelCell2 = myWorksheet.Cells(readRow + myCellRowSpan - 1, readCol + myCellColSpan -