Export SQL query result to Excel

Question

When I click a button I want to export data returned from a stored procedure to an Excel file using Asp.Net C# And Sql Server?

Do you have to use asp.net and c#? you can load the data on excel connected direct to sql server. — Ademar, Oct 24 '13 at 10:07

score 1 · Answer 1 · answered Oct 24 '13 at 10:06

1

just put your output as a table and add

 Response.ContentType = "application/vnd.xls";
 Response.AddHeader("Content-Disposition","attachment; filename=" + filName+ ".xls");

answered Oct 24 '13 at 10:06

Izikon

902
11
23

i need but the data of ( SqlDataReader ) to Excel file – Mohamed Salah Oct 24 '13 at 11:34

score 0 · Answer 2 · edited May 23 '17 at 12:28

0

You should probably be using a SDK like the OpenXMLSDK which is not specific to Microsoft, but can generate the documents in any format that can be opened across different operating systems and platforms.

For more details, the pointers are as follows,

This is used in many products and IMHO, a professional way to export data from applications.

edited May 23 '17 at 12:28

Community

1
1

answered Oct 24 '13 at 10:10

Saravanan

7,637
5
41
72

i need but the data of ( SqlDataReader ) to Excel file – Mohamed Salah Oct 24 '13 at 11:55

score 0 · Accepted Answer · answered Oct 24 '13 at 10:38

You can use COM Interop to create a new excel sheet: http://msdn.microsoft.com/en-us/library/ms173186(v=vs.80).aspx Read values from your database, then create the excelsheet.

You could also think about using the CSV format. You can easely write a ';' seperated csv file which can be imported in excel It depends on what your reason is to store in excel format.

Export SQL query result to Excel

3 Answers3