16Mar/120
Reading Excel Column Names In C# using Excel.Interop
The other day I came across an interesting question on StackOverflow asking how to get column names using Excel Interop in .NET and I set out to find the answer. It is a unique question because many people don't care what column (as in letter, so "A","B", "ZZ", etc) their data is in and may dedicate the first row to friendly column headers (as you can't change the defaults in Excel). This is what I came up with:
30Jan/1112
Excel And C# – Interop With .Net 4 – How To Read Data From Excel
With the release of .Net 4, Microsoft has made Excel Interop incredibly simple and more intuitive. While this makes using Excel files incredibly easy, it does require that the computer that is running this code has Excel installed (which may be a problem for some people). Here is what you will need to get started: