How to export Sql Server Data to Excel File in C# [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 6 months ago.

Improve this question

How can one read sql server data and write it to excel file in C#? Do I need to use an external .Net library, or is it just OK using Visual Studio itself?

Any example and link will be well appreciated..

Note: Please send examples for Winforms, not asp.net

mssqltips.com/sqlservertip/1202/… Apart from that, if you want to detour to C# you could use EPPlus to export it to Excel. — Tim Schmelter
– Tim Schmelter, Commented Jan 11, 2012 at 9:35
Wrong dupe link... try this one stackoverflow.com/questions/6526420/… — Hans Olsson
– Hans Olsson, Commented Jan 11, 2012 at 9:35

Patrick McDonald · Accepted Answer · 2014-06-26 13:47:35Z

2

I would use some kind of OR-Mapper to read data from SQL such as

NHibernate
Entity Framework
Linq 2 SQL

For writing data to Excel you could bind hardly to any Excel Version by referencing the Excel Assemblies. The cleaner and more beautiful way is to use Open XML SDK for Office http://www.microsoft.com/download/en/details.aspx?id=5124

edited Jun 26, 2014 at 13:47

Patrick McDonald

65.7k14 gold badges114 silver badges128 bronze badges

answered Jan 11, 2012 at 10:16

Thorsten Hans

2,67320 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MUS · Accepted Answer · 2012-01-11 09:34:56Z

1

Follow the below article, this even provide the facility to export the data into many formats.

Export data to Excel and other formats using C#

answered Jan 11, 2012 at 9:34

MUS

1,4504 gold badges17 silver badges30 bronze badges

Comments

4b0 · Accepted Answer · 2012-01-11 09:35:01Z

1

see:
http://www.c-sharpcorner.com/UploadFile/DipalChoksi/exportxl_asp2_dc11032006003657AM/exportxl_asp2_dc.aspx
http://geekswithblogs.net/VROD/archive/2008/04/20/121433.aspx

answered Jan 11, 2012 at 9:35

4b0

22.4k30 gold badges97 silver badges143 bronze badges

Comments

Damyan Bogoev · Accepted Answer · 2012-01-11 09:35:15Z

1

You could find helpful information how to achieve that goal in the following blog posts: 1. http://msmvps.com/blogs/deborahk/archive/2009/07/23/writing-data-from-a-datatable-to-excel.aspx 2. http://tim.mackey.ie/HowtoExportADatasetToExcelCAspnet.aspx

answered Jan 11, 2012 at 9:35

Damyan Bogoev

6964 silver badges12 bronze badges

Comments

Adam · Accepted Answer · 2012-01-11 09:40:05Z

1

See : http://www.dotnetfunda.com/forums/thread548-export-data-to-excel-file-from-a-table-in-sql-server-using-csharp.aspx

It also has a nice example on the link inside the page.

answered Jan 11, 2012 at 9:40

Adam

1,27414 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to export Sql Server Data to Excel File in C# [closed]

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Related