c# excel create a button on excel worksheet

Question

I am trying to add a button on an excel worksheet. Could you please provide a code and its not working from my end
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlBook = xlApp.Workbooks.Open(@"PATH_TO_EXCEL_FILE");
Excel.Worksheet worksheet = xlBook.Worksheets[1];

Excel.Range selection = Globals.ThisAddIn.Application.Selection as Excel.Range;
if (selection != null)
{
    Microsoft.Office.Tools.Excel.Controls.Button button =
        new Microsoft.Office.Tools.Excel.Controls.Button();
    worksheet.Controls.AddControl(button, selection, "Button");
}

Answer 1

@Rakesh kumar , based on my test, you could try the following code to add a button to your excel.

    Excel.Application xlApp = new Excel.Application();  
    Excel.Workbook xlBook = xlApp.Workbooks.Open(@"path");  
    Excel.Worksheet worksheet = xlBook.Worksheets[1];  
    Excel.Shape btn2 = worksheet.Shapes.AddFormControl(Excel.XlFormControl.xlButtonControl, 150, 5, 150, 22);  
    btn2.Name = "Update";  
    btn2.OLEFormat.Object.Caption = "UpdateButton";  
      
    xlBook.Save();  
    xlBook.Close();  

Result:

Best Regards,
Jack

---

If the answer is the right solution, please click "Accept Answer" and upvote it.If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.