锁定行头和列头的表格组件 很简单的呀. 你直接在网页里调用OWC控件, OWC控件的数据源就直接绑定为你的表格即可. 呵呵, 不要太简单了. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 to PoPoTang(泡泡棠): 我试了,可以的啊。to meizz(梅花雪): 不知道这种方法呢!有没有例子,请发个地址给我看看,8)~~~~~~~~~~~~~~~~~ meizz(梅花雪) 你的想法不错,不过客户端都要装office,麻烦一点 <html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>dictlist</title><script language="VBScript"></script><script language="JavaScript"><!--function Spreadsheet_Setting() //电子表格的基本设置{ var e = document.all.MzSpreadsheet; e.DataType = "HTMLData"; //指定表格数据源类型 e.HTMLData = document.all.data.innerHTML; //这句给控件一个数据源 e.DisplayColHeaders = 0; //列标题行 e.DisplayRowHeaders = 0; //行号列 e.titlebar.visible = 0; //标题是否显示 e.displaytoolbar = 0; //工具栏是否显示 var c = e.Constants; e.Range("c2").FreezePanes(c.ssFreezeTop); //冻结行 e.Range("b2").FreezePanes(c.ssFreezeLeft); //冻结列 e.Rows(1).Font.Bold = true; e.Rows(1).Font.Color = "red"; e.Columns(1).Font.Bold = true; var ur = e.ActiveSheet.UsedRange; ur.Font.size = "11"; ur.AutoFitRows(); ur.AutoFitColumns(); //自适应列宽显示}window.onload = function(){ Spreadsheet_Setting();}//--></SCRIPT></head><body style="overflow:hidden; margin: 0px"> <table border=0 cellpadding=0 cellspacing=0 width="100%" height="100%"> <tr> <td> <OBJECT id=MzSpreadsheet height="100%" width="100%" classid="clsid:0002E510-0000-0000-C000-000000000046"> <param name="DisplayColHeaders" value="-1"> <param name="DisplayGridlines" value="-1"> <param name="DisplayHorizontalScrollBar" value="-1"> <param name="DisplayRowHeaders" value="-1"> <param name="DisplayToolbar" value="0"> <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 id=data style="display: none"> <table border=1 width="100%"> <tr style="background-olor: blue"> <th>Serial_no</th> <th>Sex_Code</th> <th>Sex_Name</th> </tr> <tr> <td>1</td> <td>1</td> <td>男</td> </tr> <tr> <td>2</td> <td>2</td> <td>女</td> </tr> </table> </div> </td> </tr> </table></body></html> 固定Table首行(20041123)http://jkisjk.vip.sina.com/html/fixHeadTr2.htm固定Table首行首列(20041123)http://jkisjk.vip.sina.com/html/fixHeadTr3.htm 求正则表达式,包括特殊字符 求一个正则表达式 急 求一正则,验证密码不能是中文且必须以英文字母开头 Javascript 类扩展问题 csdn的高手,你是怎么形成的? help 求解关于层的几个问题。 如何得到frame中当前页面的url? js 怎么实现批量下载微信公众号后台的图片 var p in (toString:null) 什么意思 某一框架中字符替换问题,谁帮我解决,我愿送上500分,急!谢谢 表示操作成功难道只能弹alert对话框吗,有没有好看点的啊,疯啦
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>dictlist</title><script language="VBScript">
</script><script language="JavaScript">
<!--
function Spreadsheet_Setting() //电子表格的基本设置
{
var e = document.all.MzSpreadsheet;
e.DataType = "HTMLData"; //指定表格数据源类型
e.HTMLData = document.all.data.innerHTML; //这句给控件一个数据源
e.DisplayColHeaders = 0; //列标题行
e.DisplayRowHeaders = 0; //行号列
e.titlebar.visible = 0; //标题是否显示
e.displaytoolbar = 0; //工具栏是否显示 var c = e.Constants;
e.Range("c2").FreezePanes(c.ssFreezeTop); //冻结行
e.Range("b2").FreezePanes(c.ssFreezeLeft); //冻结列 e.Rows(1).Font.Bold = true;
e.Rows(1).Font.Color = "red";
e.Columns(1).Font.Bold = true; var ur = e.ActiveSheet.UsedRange;
ur.Font.size = "11";
ur.AutoFitRows();
ur.AutoFitColumns(); //自适应列宽显示}
window.onload = function()
{
Spreadsheet_Setting();
}
//-->
</SCRIPT>
</head>
<body style="overflow:hidden; margin: 0px">
<table border=0 cellpadding=0 cellspacing=0 width="100%" height="100%">
<tr>
<td>
<OBJECT id=MzSpreadsheet height="100%" width="100%"
classid="clsid:0002E510-0000-0000-C000-000000000046">
<param name="DisplayColHeaders" value="-1">
<param name="DisplayGridlines" value="-1">
<param name="DisplayHorizontalScrollBar" value="-1">
<param name="DisplayRowHeaders" value="-1">
<param name="DisplayToolbar" value="0">
<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 id=data style="display: none">
<table border=1 width="100%">
<tr style="background-olor: blue">
<th>Serial_no</th>
<th>Sex_Code</th>
<th>Sex_Name</th>
</tr>
<tr>
<td>1</td>
<td>1</td>
<td>男</td>
</tr>
<tr>
<td>2</td>
<td>2</td>
<td>女</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body></html>
http://jkisjk.vip.sina.com/html/fixHeadTr2.htm固定Table首行首列(20041123)
http://jkisjk.vip.sina.com/html/fixHeadTr3.htm