.Net pull data to an excel file

I'm developing a web application using sql sever 2005 and VS2008. I'd like to pull data from a store procedure to an excel sheet/file, as each row contains a lot of columns. I've searched the internet, and seems each way still has a problem.

Is there anyone can suggest a good way to do it?

Thanks advance.
LVL 1
minglelinchAsked:
Who is Participating?
 
minglelinchAuthor Commented:
Nice answer. Is it possible I can change the title font for the excel report generated by the above link? Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.