js怎么获取cell的值

js怎么获取cell的值和点击的行id

回复 1楼未名账户的帖子

请参考技术手册：Spread for ASP.NET 7.0 Product Documentation > Client-Side Scripting Reference > Scripting Overview > Some Simple Uses of Client Scripting > Finding the Cell Under the Cursor

1. 
   
2. <script language="javascript">
   
3.   function window.onload() {
   
4.     FpSpread1.onmousemove = test;
   
5.   }
   
6. 
   
7.   function test() {
   
8.     var col = event.srcElement.cellIndex;
   
9.     var row = event.srcElement.parentElement.rowIndex - 1;
   
10.     //we have a hidden row used for internal use
    
11.     if((!isNaN(col)) &amp;&amp; (!isNaN(row)) &amp;&amp; (0<=row) &amp;&amp; (row<FpSpread1.GetRowCount())) {
    
12.       var cell = FpSpread1.GetCellByRowCol(row,col);
    
13.       cell.style.backgroundColor = "red";
    
14.     }
    
15.   }
    
16. </script>
    
17. 
    
18. 
    

复制代码

1. <script language="javascript">
   
2.   function getactval() {
   
3.   var ret FpSpread1.GetValue(FpSpread1.ActiveRow, FpSpread1.ActiveCol);
   
4.   }
   
5. </script>
   

复制代码