Interop DLL Archive

Excel C# interop - obtaining values from cells

Working with C# and Excel has been discussed on this site before with tips on preventing Excel.exe from hanging and converting integers into Excel column headings. Today's post is a very brief example on how we can extract data from specific cells of an Excel worksheet. Obtaining a value from a specific cell Assuming we

C# adding reference error - Checking a C++ DLL is valid for a C# project

DLLs compatible with C# projects can either be managed or unmanaged. However, if they're unmanaged, they cannot be included in the project using the standard References->Add Reference->Browse->OK method, as only managed DLLs can be added in .net applications in this method. To add unmanaged DLLs you need to use a form of DLLImport, which I

Preventing Excel.exe from hanging when using the Microsoft Excel Interop DLL with C#

So it's been a bit quiet around here recently because I've been mostly working on a client project at the office which hasn't included anything onerous that I felt a quick post would be useful to aid future development. Until now. Part of the work I've been completing has included working with Microsoft Excel through