Excel Archive
24 Aug 2016
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
19 Feb 2016
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
18 Dec 2015
Convert a number to an Excel column heading
As part of a project I’ve been working on in the office, I had a need to programmatically work with Microsoft Excel. This is a fairly easy process with the Interop.Excel DLL, however, sometimes there can be a need to work with language data types and convert them in a way that can be used