Click here to Skip to main content
Click here to Skip to main content
Alternative Tip/Trick

DataSet to Excel File Conversion using ExcelLibrary

, 1 Feb 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
Hi,another alternative is this Excel C# / VB.NET component that has limited free version that can be used in commercial applications and unlimited professional version.Here is an Excel VB.NET code how to export DataSet to Excel:Dim ef = New ExcelFile()For Each dataTable As...

Editorial Note

This article appears in the Third Party Products and Tools section. Articles in this section are for the members only and must not be used to promote or advertise products in any way, shape or form. Please report any spam or advertising.

Hi,
 
another alternative is this Excel C# / VB.NET component that has limited free version that can be used in commercial applications and unlimited professional version.
 
Here is an Excel VB.NET code how to export DataSet to Excel:
Dim ef = New ExcelFile()
 
For Each dataTable As DataTable In dataSet.Tables
	ef.Worksheets.Add(dataTable.TableName).InsertDataTable(dataTable, 0, 0, True)
Next
 
ef.SaveXls(dataSet.DataSetName & ".xls")

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Robert Hutch

United States United States
No Biography provided

Comments and Discussions

 
Questionexport to excel PinmemberNekoNao21-Sep-14 20:00 
GeneralReason for my vote of 1 Your alternative (Gembox Software Fr... Pinmemberrctaubert1-Feb-12 12:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 1 Feb 2012
Article Copyright 2012 by Robert Hutch
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid