DataSet to Excel File Conversion using ExcelLibrary

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)

About the Author

Robert Hutch

United States

Member

No Biography provided

Article Top

Poor

Excellent

Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Alternative to DataSet to Excel File Conversion using ExcelLibrary

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...

Type	Tip/Trick
Licence	CPOL
First Posted	1 Feb 2012
Views	2,792
Bookmarked	4 times

ASP.NETOffice
IntermediateExcel, +

		9,892,478 members (39,039 online) Visit CodeProject.TV Discuss CodeProject.TV Sign in Email Password Forgot your password? Sign in using

DataSet to Excel File Conversion using ExcelLibrary

Editorial Note

License

About the Author

Comments and Discussions