excel-interop

Adding buttons to spreadsheets in .NET (VSTO)

Using VSTO or some related technology, is it possible to programmatically embed a button in a cell of an Excel worksheet, and configure it to call a C# function when it is clicked? How? Thanks. ...

Windows Forms above Excel

I have a form which spawns from an excel add-in written with VSTO. I would like the form to remain always above the excel spreadsheet, but still allow the user to interact with the sheet below it. The forms constructor includes this.TopLevel = true;, but the form still disappears behind the spreadsheet when I select a cell. Has anyon...

How to release excel process?

I'm using the Excel interop and it seems to be creating a process every time I call new Microsoft.Office.Interop.Excel.Application() And never ending the process even though I call xlApp.Quit(); How can I get the processes to end? ...

Prevent "Formulas have been recalculated, save" dialog?

How can I prevent the "Formulas have been recalculated, save" dialog that is launched by Excel interop when quitting the app? xlApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp); ...

How do I find which cells are selected on an Excel worksheet?

I need to be able to use C# and Excel interop to determine which cells are selected in a workbook/worksheet. It would be nice if there were something like this defined in Excel: Excel.Range Worksheet.GetSelectedCells(); But I don't find that in any documentation. How can I do this? tia. ...

ExcelInterop Program

I am creating a excel using VB.net and added micrsoftexcell com as reference to the project. when i copy the exe to other machine it is not working giving following error. Excel 2007 installed on the machine. Could not load file or assembly 'Interop.Microsoft.Office.Interop.Excel, Version=1.6.0.0, Culture=neutral, PublicKeyToken=null' o...