将数据用execl在客户端展现:
< style type = " text/css " >
{
.showTD {color: #003366; }
.hiddenTD {display:none; }
.onFocue {color: #CC66FF;}
.offFocue {color:#003366;}
}
#floater {
LEFT: 445px; POSITION: absolute; TOP: 15px; VISIBILITY: visible; WIDTH: 125px; Z-INDEX: 10}
</ STYLE >
< object classid = " clsid:0002E510-0000-0000-C000-000000000046 " id = " Spreadsheet1 " width = " 676 " height = " 388 " >
< param name = " HTMLURL " value >
< param name = " HTMLData " value = "" >
< param name = " DataType " value = " HTMLDATA " >
< param name = " AutoFit " value = " 0 " >
< param name = " DisplayColHeaders " value = " -1 " >
< param name = " DisplayGridlines " value = " -1 " >
< param name = " DisplayHorizontalScrollBar " value = " -1 " >
< param name = " DisplayRowHeaders " value = " -1 " >
< param name = " DisplayTitleBar " value = " -1 " >
< param name = " DisplayToolbar " value = " -1 " >
< param name = " DisplayVerticalScrollBar " value = " -1 " >
< param name = " EnableAutoCalculate " value = " -1 " >
< param name = " EnableEvents " value = " -1 " >
< param name = " MoveAfterReturn " value = " -1 " >
< param name = " MoveAfterReturnDirection " value = " 0 " >
< param name = " RightToLeft " value = " 0 " >
< param name = " ViewableRange " value = " 1:65536 " >
</ object >
< div class = " hiddenTD " id = " tablers " >
< table width = 95 % align = center border = 1 cellspacing = 0 cellpadding = 0 >
< tr >
< td > 客户名称A </ td >
< td > 客户名称B </ td >
< td > 客户名称C </ td >
< td > 客户名称D </ td >
< tr >
< td > abc </ td >
< td > def </ td > < td > 111 </ td > < td > 222 </ td > < tr >
< td > ddd </ td >
< td > dfdf </ td >
< td > ddd </ td >
< td > ddd </ td >
</ table >
</ div >
< script language = " javascript " >
Spreadsheet1.HTMLData = tablers.innerHTML ;
</ script >
< style type = " text/css " >
{
.showTD {color: #003366; }
.hiddenTD {display:none; }
.onFocue {color: #CC66FF;}
.offFocue {color:#003366;}
}
#floater {
LEFT: 445px; POSITION: absolute; TOP: 15px; VISIBILITY: visible; WIDTH: 125px; Z-INDEX: 10}
</ STYLE >
< object classid = " clsid:0002E510-0000-0000-C000-000000000046 " id = " Spreadsheet1 " width = " 676 " height = " 388 " >
< param name = " HTMLURL " value >
< param name = " HTMLData " value = "" >
< param name = " DataType " value = " HTMLDATA " >
< param name = " AutoFit " value = " 0 " >
< param name = " DisplayColHeaders " value = " -1 " >
< param name = " DisplayGridlines " value = " -1 " >
< param name = " DisplayHorizontalScrollBar " value = " -1 " >
< param name = " DisplayRowHeaders " value = " -1 " >
< param name = " DisplayTitleBar " value = " -1 " >
< param name = " DisplayToolbar " value = " -1 " >
< param name = " DisplayVerticalScrollBar " value = " -1 " >
< param name = " EnableAutoCalculate " value = " -1 " >
< param name = " EnableEvents " value = " -1 " >
< param name = " MoveAfterReturn " value = " -1 " >
< param name = " MoveAfterReturnDirection " value = " 0 " >
< param name = " RightToLeft " value = " 0 " >
< param name = " ViewableRange " value = " 1:65536 " >
</ object >
< div class = " hiddenTD " id = " tablers " >
< table width = 95 % align = center border = 1 cellspacing = 0 cellpadding = 0 >
< tr >
< td > 客户名称A </ td >
< td > 客户名称B </ td >
< td > 客户名称C </ td >
< td > 客户名称D </ td >
< tr >
< td > abc </ td >
< td > def </ td > < td > 111 </ td > < td > 222 </ td > < tr >
< td > ddd </ td >
< td > dfdf </ td >
< td > ddd </ td >
< td > ddd </ td >
</ table >
</ div >
< script language = " javascript " >
Spreadsheet1.HTMLData = tablers.innerHTML ;
</ script >
示例效果: