VB.net 2010 视频教程 VB.net 2010 视频教程 python基础视频教程
SQL Server 2008 视频教程 c#入门经典教程 Visual Basic从门到精通视频教程
当前位置:
首页 > c#编程 >
  • VSTO 撤回代码修改的值

不废话,直接代码

private Stack<Action> actionStack = new Stack<Action>();

private void SetCellValues()
{
    var worksheet = Globals.ThisAddIn.Application.ActiveSheet as Excel.Worksheet;

    var range = worksheet.Range["A1"];
    var previousValue = range.Value2;

    // 保存当前状态以便恢复
    actionStack.Push(() =>
    {
        range.Value2 = previousValue;
    });

}

private void UndoLastOperation()
{
    if (actionStack.Count > 0)
    {
        var undoAction = actionStack.Pop();
        undoAction();
    }
}

来源:https://www.cnblogs.com/xt_hjl/p/18210702


相关教程