求大神指教

使用FarPoint 打开Excel后
原Excel是N行4列，增加第五列为Button按钮
目的：想在点击按钮时触发后台处理事件，获取当前选中的行。
当前已生成按钮：
FpSpread1.ActiveSheetView.Cells[i, dataSetAppReg.Tables[0].Rows.Count+1].CellType = new FarPoint.Web.Spread.ButtonCellType("FpSpread1_ButtonCommand",FarPoint.Web.Spread.ButtonType.PushButton,"保存");
请教大神告知！这样生成按钮是否正确？如何用生成的按钮调用后台事件？
谢谢！

回复 1楼怕瓦落地的帖子

正确。

生成按钮和事件对应的代码如下，请参考：

1. 
   
2. FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType("MyRed");
   
3. FarPoint.Web.Spread.ButtonCellType btn1 = new FarPoint.Web.Spread.ButtonCellType("MyBlue");
   
4. FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
   
5. FarPoint.Web.Spread.StyleInfo style1 = new FarPoint.Web.Spread.StyleInfo();
   
6. FpSpread1.Sheets[0].ColumnCount = 7;
   
7. FpSpread1.Sheets[0].RowCount = 50;
   
8. btn.ButtonType = FarPoint.Web.Spread.ButtonType.PushButton;
   
9. btn1.ButtonType = FarPoint.Web.Spread.ButtonType.PushButton;
   
10. btn.CommandName = "MyRed";
    
11. btn1.CommandName = "MyBlue";
    
12. style.CellType = btn;
    
13. style1.CellType = btn1;
    
14. FpSpread1.Sheets[0].SetStyleInfo(-1, 0, style);
    
15. FpSpread1.Sheets[0].SetStyleInfo(-1, 1, style1);
    
16. 
    
17. private void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
    
18. {
    
19.     if(e.CommandName == "MyRed")
    
20.     {
    
21.         FpSpread1.BackColor = Color.Red;
    
22.     }
    
23.     else if(e.CommandName == "MyBlue")
    
24.     {
    
25.         FpSpread1.BackColor = Color.Blue;
    
26.     }
    
27. }
    

复制代码

回复 2楼roger.wang的帖子

感谢大神！已解决！谢谢！

回复 3楼怕瓦落地的帖子

nice