Learning project:
I would like to know how to? use asp.net to return values from a stored procedure as an excel spread sheet.? I have looked at a few examples online in which excel is used to open HTML returned from values in a gridview control but this is not what I want.?
I want to see asp.net query a database (stored proc or inline sql, doesn't matter) and return a REAL excel spreadsheet with column headers matching the columns returned from the query.? Also, I would like to see how two queries can be used to make multiple sheets in a single excel file.
Can you help?!? Please bid!
## Deliverables
I want this code to be able to return a large set of data (30k to 50k records) without bogging down a server...Performance is important.