Click here to Skip to main content
Click here to Skip to main content

DataSet to Excel in Two steps – with Different Styles

, 30 Jul 2005
Rate this:
Please Sign up or sign in to vote.
Cool Component exports DataSet(s) to Excel as Row-wise,Column-wise or Sheet-wise.

Sample Image - datasettoexcel.jpg


This component exports a DataSet to Microsoft Excel. You can also export more than one multiple DataSets at a time. This component handles disposing of Excel objects and cleaning up of memory automatically. So there is no worry of memory leakage!! Just two lines of code to export your DataSet to Excel. This is a free component.

Note: You need Excel to be installed in your system.

Different Styles

Different styles that are available are:

  • Row Wise: Exports each DataTable in the DataSet in row-wise in Excel.
  • Column Wise: Exports each DataTable in the DataSet in column-wise in Excel.
  • Sheet Wise: Exports each DataTable in the DataSet in one worksheet.

Other features and formatting styles

You can set the following:

  • HeaderForeColor
  • HeaderBackColor
  • ItemForeColor
  • ItemBackColor
  • ItemAlternateBackColor
  • FontStyle
  • RowsSpace
  • ColumnSpace
  • TableSpace

Sample Code

Utilities.ExcelExport.Export excel = 
                    new Utilities.ExcelExport.Export();
//Pass your Dataset and Specify the style.


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author


United Arab Emirates United Arab Emirates
Software Engineer from India,Working in .NET for 2 years.

Comments and Discussions

GeneralMy vote of 4 PinmemberSatyavir Yadav from New Delhi22-Apr-13 2:13 
QuestionError on Line workbook = workbooks.Add(true); on Windows Server 2008 + IIS 7 Pinmemberkeyur_parekh24-Oct-12 4:51 
QuestionThe Solution works great but.. PinmemberPooja H Borhade1-Nov-11 21:02 
AnswerRe: The Solution works great but.. PinmemberAbdallah Al-Dalleh20-Jul-14 23:11 
QuestionWell Done! PinmemberTadesse21-Jun-11 11:06 
GeneralMy vote of 1 Pinmembernavbingo2026-May-11 0:52 
GeneralRe: My vote of 1 Pinmemberrama charan25-Jun-12 0:53 
QuestionErrors when compiling your source code in Visual Studio 2010 Pinmembermoiztankiwala10-Jun-10 10:29 
AnswerRe: Errors when compiling your source code in Visual Studio 2010 PinmemberTadesse21-Jun-11 10:52 
Generalthank's!, works if Pinmembercheluskis10-Sep-09 10:03 
Questionformulas PinmemberSilentSage31-Dec-08 3:48 
QuestionExcel Export Pinmemberdrshreya18-Sep-08 9:02 
GeneralYou are really the best Pinmemberminatharwat23-Jan-07 11:55 
GeneralTakes ages .... Pinmemberoobject5-Sep-06 20:19 
GeneralRe: Takes ages .... [modified] PinmemberTim Schwallie30-Jan-07 10:01 
GeneralRe: Takes ages .... PinmemberTim Schwallie31-Jan-07 4:20 
GeneralRe: Takes ages .... PinmemberCikaPero28-Feb-10 21:27 
QuestionApplication will not open but process does open PinmemberMariaelisau6-Jul-06 9:50 
GeneralSpecifing Excel File Name PinmemberAli Hussian Al-Faraj6-Jun-06 21:20 
GeneralAssemblies missing Pinmemberlbispo4-May-06 5:30 
GeneralAccess Denied error Pinmembersrichikka2-May-06 23:01 
GeneralRe: Access Denied error PinmemberMukesh_B27-Aug-06 22:36 
GeneralAccess is denied. Pinmemberoneforall201228-Apr-06 8:53 
QuestionWhere's the article? Pinmemberexhaulted21-Feb-06 23:03 
GeneralAccess is denied PinmemberL. Des Lierres21-Feb-06 8:01 

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
Web04 | 2.8.140821.2 | Last Updated 31 Jul 2005
Article Copyright 2005 by Krishna_accent
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid