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.

Set cell value using Excel interop

Ok, so I'm trying to set the value of a cell with the excel interop library. I am able to …

c# excel-interop
Microsoft Office Excel cannot access the file 'c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx'

I have my code as follows :- Microsoft.Office.Interop.Excel.Application oXL = null; Microsoft.Office.Interop.Excel.Sheets sheets; …

c# excel export-to-excel excel-interop
Class not registered error when creating Excel workbook in C#

When I try to access an Excel spreadsheet using the following code I get a "Library not registered' error when …

c# .net excel excel-interop
C# - How do I iterate all the rows in Excel._Worksheet?

I am looking to programmatically pull data from an Excel worksheet and insert it into a database table. How do …

c# excel excel-2007 excel-interop
How to Save/Overwrite existing Excel file with Excel Interop - C#

Is there a way to save changes to an excel spreadsheet through the excel interop (in this case I am …

c# excel excel-interop
Cannot close Excel.exe after Interop process

I'm having an issue with Excel Interop. The Excel.exe doesn't close even if when I realease instances. Here is …

c# winforms excel-interop
Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX) for System.Runtime.InteropServices.COMException

I have a part of code which tries to export data (from database) to Excel. When I am trying to …

c# .net excel interop excel-interop
Read Excel First Column using C# into Array

I'm trying to read in the values of the first column into an array. What's the best way to do …

c# excel excel-interop
Microsoft.Office.Interop.Excel: How to Apply a border to ONE CELL

I am looking to apply a border to one cell using the Microsoft.Office.Interop.Excel library. I am running …

c# excel border cell excel-interop
Converting Timespan to DateTime in C#

I am reading Excel worksheet data using C# and Microsoft.Office.Interop. The sheet contains some date values. When I …

c# datetime excel-interop ole-automation