I'm fairly new to programming with Interop.Excel and may lack the experience, but why is it such a pain to program with it? Casting objects everywhere, more or less no documentation on the methods (at least not in the code) and every method seems to return objects, so there is no way of telling what it actually does. Also, all arguments are objects to begin with.
Is there any good wrapper library out there that provides basic functionality (writing to cells, reading, creating sheets, deleting sheets, basic formatting and layouting) and does this in a good, clean and understandable (and by that I mean: well-documented) way?
PS: Working with C# and .NET-3.5
I'm using EPPlus and very happy with it. It's open source and free.
The owners offer support when ever it was required.
Note that EPPlus doesn't support Excel 2003 format. .xlxs is supported while. xls is not.