<script language="javascript" type="text/javascript">
/* * 默认转换实现函数，如果需要其他功能，需自行扩展
* 参数：
* tableid : html中table对象id属性值
* 详细用法参见以下 tabletoexcel 对象定义
*/
function saveasexcel(tableid){
var tb = new tabletoexcel(tableid);
tb.setfontstyle("courier new");
tb.setfontsize(10);
tb.settableborder(2);
tb.setcolumnwidth(7);
tb.islinewrap(true);
tb.getexcelfile();
}
/** 功能：html中table对象转换为excel通用对象.
* 参数：tableid html中table对象的id属性值
* 说明：
* 能适应复杂的html中table对象的自动转换，能够自动根据行列扩展信息
* 合并excel中的单元格，客户端需要安装有excel
* 详细的属性、方法引用说明参见：excel的microsoft excel visual basic参考
* 示范：
* var tb = new tabletoexcel('demotable');
* tb.setfontstyle("courier new");
* tb.setfontsize(10); //推荐取值10
* tb.setfontcolor(6); //一般情况不用设置
* tb.setbackground(4); //一般情况不用设置
* tb.settableborder(2); //推荐取值2
* tb.setcolumnwidth(10); //推荐取值10
* tb.islinewrap(false);
* tb.isautofit(true);
* * tb.getexcelfile();
* 如果设置了单元格自适应，则设置单元格宽度无效
* 版本：1.0*/
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 () {
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;
myworkbook = jxls.workbooks.add();
jxls.displayalerts = false;
myworkbook.worksheets(3).delete();
myworkbook.worksheets(2).delete();
jxls.displayalerts = true;
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 (x = 0; x < obj.length; x++) {
if (obj[x].id == this.tableid) {
tabnum = x;
totalrow = obj[x].rows.length;
for (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 (i = 0; i <= totalrow; i++) {
exceltable[i] = new array();
for (t = 0; t <= totalcol; t++) {
exceltable[i][t] = false;
}
}
//开始转换表格
for (z = 0; z < obj[tabnum].rows.length; z++) {
readrow = z + 1;
readcol = 0;
for (c = 0; c < obj[tabnum].rows(z).cells.length; c++) {
myhtmltablecell = obj[tabnum].rows(z).cells(c);
mycellcolspan = myhtmltablecell.colspan;
mycellrowspan = myhtmltablecell.rowspan;
for (y = 1; y <= totalcol; y++) {
if (exceltable[readrow][y] == false) {
readcol = y;
break;
}
}
if (mycellcolspan * mycellrowspan > 1) {
myexcelcell = myworksheet.cells(readrow, readcol);
myexcelcell2 = myworksheet.cells(readrow + mycellrowspan - 1, readcol + mycellcolspan - 1);
myworksheet.range(myexcelcell, myexcelcell2).merge();
myexcelcell.horizontalalignment = this.textalign;
myexcelcell.font.size = this.fontsize;
myexcelcell.font.name = this.fontstyle;
myexcelcell.wraptext = this.linewrap;
myexcelcell.interior.colorindex = this.background;
myexcelcell.font.colorindex = this.fontcolor;
if(this.tableborder != -1){
myworksheet.range(myexcelcell, myexcelcell2).borders(1).weight = this.tableborder ;
myworksheet.range(myexcelcell, myexcelcell2).borders(2).weight = this.tableborder ;
myworksheet.range(myexcelcell, myexcelcell2).borders(3).weight = this.tableborder ;
myworksheet.range(myexcelcell, myexcelcell2).borders(4).weight = this.tableborder ;
}
myexcelcell.value = myhtmltablecell.innertext;
for (row = readrow; row <= mycellrowspan + readrow - 1; row++) {
for (col = readcol; col <= mycellcolspan + readcol - 1; col++) {
exceltable[row][col] = true;
}
}
readcol = readcol + mycellcolspan;
} else {
myexcelcell = myworksheet.cells(readrow, readcol);
myexcelcell.value = myhtmltablecell.innertext;
myexcelcell.horizontalalignment = this.textalign;
myexcelcell.font.size = this.fontsize;
myexcelcell.font.name = this.fontstyle;
myexcelcell.wraptext = this.linewrap;
myexcelcell.interior.colorindex = this.background;
myexcelcell.font.colorindex = this.fontcolor;
if(this.tableborder != -1){
myexcelcell.borders(1).weight = this.tableborder ;
myexcelcell.borders(2).weight = this.tableborder ;
myexcelcell.borders(3).weight = this.tableborder ;
myexcelcell.borders(4).weight = this.tableborder ;
}
exceltable[readrow][readcol] = true;readcol = readcol + 1;
}
}
}
if(this.autofit == true)
myworksheet.columns.autofit;
jxls.usercontrol = true;
jxls = null;
myworkbook = null;
myworksheet = null;
};
以下内容为网络搜集，方便自己使用。出处不详（我忘了从哪找的了，呵呵）。
-------------------------------------------------------------------------------------------------------------------------------------
使用javascript中的activexobject填充并设置excel格式
1.创建实例并创建工作表
var xlobj = new activexobject("excel.application");//创建excel实例
var xlbook = xlobj.workbooks.add; //新增工作簿
var excelsheet = xlbook.worksheets(1); //创建工作表
2.保存表格
excelsheet.saveas("c:\\test.xls");
3.使 excel 通过 application 对象可见
excelsheet.application.visible = true;或者excelsheet.visible=true;
4.打印
xlbook.printout;或者:excelsheet.printout;
5.关闭
xlbook.close(savechanges=false);或者excelsheet.close(savechanges=false);
6.结束进程
excelsheet.application.quit()或者xlobj.quit(); xlobj=null;
7.页面设置
excelsheet.activesheet.pagesetup.leftmargin= 2/0.035; //页边距 左2厘米
excelsheet.activesheet.pagesetup.rightmargin = 3/0.035; //页边距 右3厘米，
excelsheet.activesheet.pagesetup.topmargin = 4/0.035; //页边距 上4厘米，
excelsheet.activesheet.pagesetup.bottommargin = 5/0.035; //页边距 下5厘米
excelsheet.activesheet.pagesetup.headermargin = 1/0.035; //页边距 页眉1厘米
excelsheet.activesheet.pagesetup.footermargin = 2/0.035; //页边距 页脚2厘米
excelsheet.activesheet.pagesetup.centerheader = "页眉中部内容";
excelsheet.activesheet.pagesetup.leftheader = "页眉左部内容";
excelsheet.activesheet.pagesetup.rightheader = "页眉右部内容";
excelsheet.activesheet.pagesetup.centerfooter = "页脚中部内容";
excelsheet.activesheet.pagesetup.leftfooter = "页脚左部内容";
excelsheet.activesheet.pagesetup.rightfooter = "页脚右部内容";
8.对单元格操作，带*部分对于行，列，区域都有相应属性
excelsheet.activesheet.cells(row,col).value = "内容"; //设置单元格内容
excelsheet.activesheet.cells(row,col).borders.weight = 1; //设置单元格边框*()
excelsheet.activesheet.cells(row,col).interior.colorindex = 1; //设置单元格底色*(1-黑色，2-白色，3-红色，4-绿色，5-蓝色，6-黄色，7-粉红色，8-天蓝色，9-酱土色..可以多做尝试)
excelsheet.activesheet.cells(row,col).interior.pattern = 1; //设置单元格背景样式*(1-无，2-细网格，3-粗网格，4-斑点，5-横线，6-竖线..可以多做尝试)
excelsheet.activesheet.cells(row,col).font.colorindex = 1; //设置字体颜色*(与上相同)
excelsheet.activesheet.cells(row,col).font.size = 10; //设置为10号字*
excelsheet.activesheet.cells(row,col).font.name = "黑体"; //设置为黑体*
excelsheet.activesheet.cells(row,col).font.italic = true; //设置为斜体*
excelsheet.activesheet.cells(row,col).font.bold = true; //设置为粗体*
excelsheet.activesheet.cells(row,col).clearcontents; //清除内容*
excelsheet.activesheet.cells(row,col).wraptext=true; //设置为自动换行*
excelsheet.activesheet.cells(row,col).horizontalalignment = 3; //水平对齐方式枚举* (1-常规，2-靠左，3-居中，4-靠右，5-填充 6-两端对齐，7-跨列居中，8-分散对齐)
excelsheet.activesheet.cells(row,col).verticalalignment = 2; //垂直对齐方式枚举*(1-靠上，2-居中，3-靠下，4-两端对齐，5-分散对齐)
//行，列有相应操作:
excelsheet.activesheet.rows(row).
excelsheet.activesheet.columns(col).
excelsheet.activesheet.rows(startrow+":"+endrow). //如rows("1:5")即1到5行
excelsheet.activesheet.columns(startcol+":"+endcol). //如columns("1:5")即1到5列
//区域有相应操作:
xlobj.range(startcell+":"+endcell).select;
//如range("a2:h8")即a列第2格至h列第8格的整个区域
xlobj.selection.
//合并单元格
xlobj.range(startcell+":"+endcell).mergecells = true;
//如range("a2:h8")即将a列第2格至h列第8格的整个区域合并为一个单元格
或者:xlobj.range("a2",xlobj.cells(8, 8)).mergecells = true;
9.设置行高与列宽
excelsheet.activesheet.columns(startcol+":"+endcol).columnwidth = 22;//设置从firstcol到stopcol列的宽度为22
excelsheet.activesheet.rows(startrow+":"+endrow).rowheight = 22;//设置从firstrow到stoprow行的宽度为22
var myrange osheet.range(osheet.cells(2,1),osheet.cells(2,6));
myrange.columns.autofit()
myrange.rows.autofit()//好像不太管用
//设置该区域为自适应高度和宽度
使用javascript将表格内容导出到excel的方式
1.整个表格拷贝到excel中
function copytable(tableid)
{
//整个表格拷贝到excel中
var curtbl = document.getelementbyid(tableid);
var oxl = new activexobject("excel.application");
//创建ax对象excel
var owb = oxl.workbooks.add();
//获取workbook对象
var osheet = owb.activesheet;
//激活当前sheet
var sel = document.body.createtextrange();
sel.movetoelementtext(curtbl);
//把表格中的内容移到textrange中
sel.select();
//全选textrange中内容
sel.execcommand("copy");
//复制textrange中内容
osheet.paste();
//粘贴到活动的excel中
oxl.visible = true;
//设置excel可见属性
}
2.把单元格内容拷贝到excel,并设置单元格格式.
function method2(tableid) //读取表格中每个单元到excel中
{
var curtbl = document.getelementbyid(tableid);
var oxl = new activexobject("excel.application");
//创建ax对象excel
var owb = oxl.workbooks.add();
//获取workbook对象
var osheet = owb.activesheet;
//激活当前sheet
var lenr = curtbl.rows.length;
var y=document.getelementbyid('dropyear');
var m=document.getelementbyid('dropmonth');
//取得表格行数
osheet.cells( 1, 1).value='商户名称：工商银行商城';
osheet.range(osheet.cells(1,1),osheet.cells(1,6)).merge()
osheet.cells(2,1).value=日期; '+y.options[y.selectedindex].value+'-'+m.options[m.selectedindex].value;
osheet.range(osheet.cells(2,1),osheet.cells(2,6)).merge()
osheet.cells( 3, 1).value='销售情况'
osheet.range(osheet.cells(3,1),osheet.cells(3,6)).merge()
osheet.cells( 3, 1).horizontalalignment=3;
osheet.cells( 3, 1).font.size=14;
osheet.cells( 3, 1).font.bold = true;
osheet.range(osheet.cells(4,1),osheet.cells(4,6)).merge()
osheet.cells(4,1).value=document.getelementbyid('lbmessage').innertext;
for (i = 0; i < lenr; i++)
{
var lenc = curtbl.rows(i).cells.length;
//取得每行的列数
for (j = 0; j < lenc; j++)
{
osheet.cells(i + 5, j + 1).value = curtbl.rows(i).cells(j).innertext;
//赋值
}
}
osheet.cells(i+6,2).value=document.getelementbyid('hidsum').value;
osheet.columns.autofit();
osheet.rows.autofit();
osheet.rows(4).rowheight = 30;
oxl.visible = true;
//设置excel可见属性
oxl.quit();
oxl = null;
idtmr = window.setinterval("cleanup();",1);//强制释放资源
}
function cleanup()//清除excel资源
{
window.clearinterval(idtmr);
collectgarbage();
}
使用javascript按照表格格式复制内容到剪切板
1.在excel中进行粘贴
function copytable()
{
var content=''
var tb=document.getelementbyid('gvmain');
var rows=tb.rows;
for(var i=0;i<rows.length;i++)
{
var cells=rows[i].cells;
for(var j=0;j<cells.length;j++)
{
content +=cells[j].innertext.tostring()+'\t';
}
content +='\n';
}
if(content!='')
{
clipboarddata.setdata("text",content);
alert("复制成功!")
}
}
以上就是用javscript导出html中的数据到excel表格中的详细内容。