Top "Excel-interop" questions

Excel Interop is the layer using the COM Interop that allows .NET (VB or C#) to communicate with standard COM objects and libraries.

How to Delete a Column Programmatically?

How does one delete a column (or multiple columns) in Excel? eg. How to delete column C and shift the …

c# excel excel-interop
Changing an Excel cell's backcolor using hex results in Excel displaying completely different color in the spreadsheet

So I am setting an Excel cell's Interior Color to a certain value, like below: worksheet.Cells[1, 1].Interior.Color = 0xF1…

c# excel interop excel-interop vba
Cannot open Excel file in C#

I have the following C# function in my project, which is supposed to open and return an existing Excel workbook …

c# excel-interop
writing data from C# to Excel interrupted by opening Excel Window

While my C# program writes data continuously to an Excel spreadsheet, if the end user clicks on the upper right …

c# .net excel excel-interop
Fastest method to remove Empty rows and Columns From Excel Files using Interop

I have a lot of excel files that contains data and it contains empty rows and empty columns. like shown …

c# excel vb.net optimization excel-interop
Safely disposing Excel interop objects in C#?

i am working on a winforms c# visual studio 2008 application. the app talks to excel files and i am using …

c# excel interop dispose excel-interop
How to copy a sheet with a different name - C# and Excel Interop

I would like to simply copy one sheet within my workbook and give it a different name. var pointName1 = workbook.…

c# excel interop excel-interop
Getting excel application process id

I am creating an excel application with c#. Since I will maintain the excel file in urgency I want to …

c# excel-interop
Why does Microsoft.Office.Interop.Excel.Application.Quit() leave the background process running?

The following code leaves a Microsoft Excel background process running, until after my program has exited: var excelApplication = new Application(); …

c# excel office-interop excel-interop
Excel Get_Range with multiple areas

I'm trying to get a range from Excel, which has multiple areas specified, essentially I've got... int StartColumn int EndColumn …

c# excel excel-interop