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.

Microsoft.Office.Interop.Excel.ApplicationClass has no constructor defined

I tried to follow How to open an Excel file in C# tutorial, i.e. added a reference on the …

c# excel interop excel-interop
Get all worksheet names in plaintext from Excel with C# Interop?

I'm using VS2010 + Office Interop 2007 to attempt to get a few specific spreadsheet names from an Excel spreadsheet with 5-6 …

c# excel excel-interop
How to iterate through Excel Worksheets only extracting data from specific columns

How do you iterate through an excel workbook with multiple worksheets only extracting data from say columns "C", "E" & "…

c# excel .net-4.0 excel-interop
How to close-without-save an Excel /xlsm workbook, w/ a custom function, from C#

I have an Excel workbook with a custom non-time-dependent cell function that I am opening from a C# WindowsForms application …

c# excel excel-interop
How to generate a chart from an Excel sheet?

I can generate an Excel file when I pass a datatable into the below function: public static void ExportDataTableToExcel(DataTable …

c# excel charts excel-interop
How to check if the Worksheet already exist in Interop

I want to check if the sheet exists before creating it. using Excel = Microsoft.Office.Interop.Excel; Excel.Application excel = …

c# excel excel-interop
Microsoft Interop: Excel Column Names

I am using Microsoft Interop to read the data. In excel-sheet the column-names are like A,B,C,D,....,AA,…

c# office-interop excel-interop
microsoft.interop.excel Formatting cells

I am building a report using the microsoft.interop.excel library in C#. I have something like this: Range rangeTarget; . . . …

c# excel formatting office-interop excel-interop
How to rename excel sheet name dynamically in C#

I have created an excel workbook with many sheets like sheet1, sheet2,... etc. How can I rename these tab names …

c# .net excel excel-interop
How to read a empty cell value using EXCEL interop api in C#.net?

I am getting a System.com_object error if I am trying to read the EXCEL cell which is empty. …

c#-4.0 excel-2010 excel-interop