Reference Material for using C#.net to generate Excel Reports
Posted on 2006-04-10
At work, our department is starting to use C#.net for web development. C#.net, being new to just about all our former VB 6 developers, means that we don't have much expertise.
The project I have been tasked with is to create Excel documents/reports from Oracle tables.
I have had luck using Response.Write() commands getting data grids and straight text down to Excel. But I have been unable to perform basic Excel formatting like landscape orientation or manual page breaks.
What I am really looking for is a good reference on generating Excel documents from a C#.net web application that gives examples on performing a degree of formatting. My trips looking through Borders Books' computer section and Google/Yahoo searches have been frustrating.