I'd like to output data from Visual Basic to an Excel Document. I don't want to create a CSV or anything like that, I'd like to create an XLS file.
I'm going to need to do things like change the formatting of the text I output, maybe put some color in. I think I have to use an Excel Object, but I'm not sure how to use it.
Any code showing me how to create a new Excel document and output data to it would be great. And if you can show me how to change font, color, and create freeze panes, I'll throw in some more points.