求大神指教

收藏

使用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,"保存");
请教大神告知！这样生成按钮是否正确？如何用生成的按钮调用后台事件？
谢谢！

roger.wang · roger.wang

回复 1楼怕瓦落地的帖子

正确。

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

FarPoint.Web.Spread.ButtonCellType btn = new FarPoint.Web.Spread.ButtonCellType("MyRed");
FarPoint.Web.Spread.ButtonCellType btn1 = new FarPoint.Web.Spread.ButtonCellType("MyBlue");
FarPoint.Web.Spread.StyleInfo style = new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.StyleInfo style1 = new FarPoint.Web.Spread.StyleInfo();
FpSpread1.Sheets[0].ColumnCount = 7;
FpSpread1.Sheets[0].RowCount = 50;
btn.ButtonType = FarPoint.Web.Spread.ButtonType.PushButton;
btn1.ButtonType = FarPoint.Web.Spread.ButtonType.PushButton;
btn.CommandName = "MyRed";
btn1.CommandName = "MyBlue";
style.CellType = btn;
style1.CellType = btn1;
FpSpread1.Sheets[0].SetStyleInfo(-1, 0, style);
FpSpread1.Sheets[0].SetStyleInfo(-1, 1, style1);
private void FpSpread1_ButtonCommand(object sender, FarPoint.Web.Spread.SpreadCommandEventArgs e)
{
if(e.CommandName == "MyRed")
{
FpSpread1.BackColor = Color.Red;
}
else if(e.CommandName == "MyBlue")
{
FpSpread1.BackColor = Color.Blue;
}
}

复制代码

怕瓦落地 · 怕瓦落地

回复 2楼roger.wang的帖子

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

roger.wang · roger.wang

回复 3楼怕瓦落地的帖子

nice

		自动登录	找回密码
密码			立即注册

[已处理] 求大神指教

3 个回复

活字格认证

微信认证勋章

元老葡萄