Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / how to export data in excel file from sql server using c# code?
Ask Question

How to export data in excel file from sql server using c# code?

Anonymous User 7985 10 Apr 2012
Hello Everyone,
I'm facing a problem since last night, Actually I want to export SQL Server table data in MS-Excel file but I don't have idea how do it. Please help me as soon as possible.
Thanks in advance!!
c# c#
Updated 03 Dec 2013
Anonymous User
Anonymous User

Other

I am a content writter !

Message

3 Answers

Nibaal Bazzi
Nibaal Bazzi 03 Dec 2013
Report Abuse
Hi, MindStick DataConverter is really a very neat and straightforward software, but it seems it is stuck on version: 1.0.0.0.
I hope there will be some additional improvements in the future, for example a support for newer XLSX file format.
Nevertheless Tanuj you can try this C# Excel class library, I found it very helpful in spreadsheet to database communication tasks.
Here is how you can export Excel file to a DataTable in C#:

// Load Excel file.
ExcelFile workbook = ExcelFile.Load("Workbook.xlsx");
// Select active worksheet from the file.
ExcelWorksheet worksheet = workbook.Worksheets.ActiveWorksheet;
// Extract the data from the worksheet to newly created DataTable.
DataTable dataTable = worksheet.CreateDataTable(new CreateDataTableOptions()
{
    StartRow = 0,
    StartColumn = 0,
    ColumnHeaders = true,
    ExtractDataOptions = ExtractDataOptions.StopAtFirstEmptyRow
});

Anonymous User
Anonymous User 11 Apr 2012
Report Abuse

Hi Tanuj Kumar,
Please check out this link.....
https://www.mindstick.com/blog/294/how-to-import-or-export-sql-server-table-data-in-ms-excel-sheet-using-c-sharp-code
It might be resolve this problem. You can also use MindStick DataCoverter to resolve this problem. It helps you to export and import data from different file format. To download MindStick DataConverter, please click here.

Anonymous User
Anonymous User 11 Apr 2012
Report Abuse
Post is removed by the User.
advertising