在这个颜值当道,屌丝闪边的时代,拼不过颜值拼内涵,只有知识丰富才能提升一个人的内在气质和修养,所谓人丑就要多学习,今天给大家分享的原样导出到,希望可以对大家能有小小的帮助。
function PrintTableToExcelEx(objTab)
...{
try
...{
var xls = new ActiveXObject( "" );
}
catch(e)
...{
alert( "您必须安装Excel电子表格软件,同时浏览器须使用“ActiveX 控件”,您的浏览器须允许执行控件。 请点击了解浏览器设置方法!");
return false;
}
= true;
var xlBook= ;
var xlsheet = ();
var CurX = 1;
var CurY = 1;
for (var i = 0; i ; i++)
...{
for (var j = 0; j ; j++)
...{
var cell = ];
var v = ;
if ( != null && .length != 0 )
...{
v = "";
for ( var k = 0; k .length; k++ )
...{
var cc = [k];
switch ()
...{
case "select-one":
for ( var l = 0; l ; l++ )
if ( )v += ;
break;
case "text":
v += ;
break;
case "checkbox":
v += ? "是" : "否";
break;
case undefined:
v += ;
break;
case "hidden":
break;
default:
//v += cc.id + "/";
//v += + "/";
//v += + "/"
v += ;
break;
}
}
}
while ( (,) )CurY++;
(CurX, CurY).HorizontalAlignment = 2;
var align = ("");
switch ( align )
...{
case "left":
(CurX, CurY).HorizontalAlignment = 2;//;
break;
case "center":
(CurX, CurY).HorizontalAlignment = 3;;//;
break;
case "right":
(CurX, CurY).HorizontalAlignment = 4;//;
break;
}
(CurX, CurY).WrapText = true;
(CurX, CurY).VerticalAlignment = 2;
(CurX, CurY).Value = v;
(CurX, CurY). = 1;
var rowSpan = ("");
var colSpan = ("");
if ( rowSpan = 2 || colSpan = 2 )
...{
var R = ((CurX, CurY), (CurX + rowSpan - 1, CurY + colSpan - 1));
= true;
R. = 1;
}
CurY++;
}
CurX++;
CurY = 1;
}
; //自动适应大小
return;
}
调用:
INPUT type="button" value="导出"