1000字范文,内容丰富有趣,学习的好帮手!
1000字范文 > ASP.NET的HTMLTable原样导出到Excel

ASP.NET的HTMLTable原样导出到Excel

时间:2024-06-22 22:31:44

相关推荐

ASP.NET的HTMLTable原样导出到Excel

在这个颜值当道,屌丝闪边的时代,拼不过颜值拼内涵,只有知识丰富才能提升一个人的内在气质和修养,所谓人丑就要多学习,今天给大家分享的原样导出到,希望可以对大家能有小小的帮助。

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="导出"

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。