Click here to Skip to main content
13,349,539 members (53,202 online)
Click here to Skip to main content
Add your own
alternative version


74 bookmarked
Posted 15 Oct 2008

Excel export from DatagridView

, 15 Oct 2008
Rate this:
Please Sign up or sign in to vote.
A way to export data to native excel (xls) from a Datagridview with any data source


A very common problem in winform applications occurs when data should be exported from DatagridView to Excel, there's some commercial workarounds to solve this problem. This article describe a simple versatile and free way to do.


The work to exporting to Excel is made by "Office XP Primary Interop Assemblies (PIAs)"

Initially, the data is obtained from datagridview's datasource, formated and then exported to a excel file throw Excel COM Interiop. 

The Datagridview datasource could be :

  • ArrayList of Entities 
  • Dataset with at least 1 datatable
  • Datatable

Data should be stored in a DataTable before beign exported to excel, if DataGridView's DataSource is an ArrayList, then the ArrayList is converted to a DataTable using the method ArrayListToDataTable

ArrayList arr = (ArrayList)dataGridView.DataSource;
       dt = ArrayListToDataTable(arr);

 Once the data is stored in the datatable is exported to excel using the method dataTable2Excel

dataTable2Excel(dt, dataGridView, pFullPath_toExport, nameSheet);


Using the code

You should only copy the following 2 files to your project 

  • ExportToExcel.cs
  • UC_DataGridView.cs
  • UC_DataGridView.Designer.cs

Use the DataGridView in you project and export to excel using the next code

Tools.ExportToExcel.ExportToExcel exp = new Tools.ExportToExcel.ExportToExcel(); 
exp.dataGridView2Excel(this.dgvDataToExport, path, "NameSheet"); 

Points of Interest 

Please note that the titles in excel file was obtained from DataGridView headers, not from DataTable name columns. 

There's a bug, titles of columns are not exported correct, i am working on it. 


15/10/2008 First Release


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


About the Author

Software Developer
Peru Peru
Kevin Diaz is an electrical engineer by UNI in Lima, Peru.

He work developing projects for electrical industry.

You may also be interested in...

Comments and Discussions

GeneralMy vote of 4 Pin
yichangzyh4-Jan-12 1:26
memberyichangzyh4-Jan-12 1:26 
GeneralDatagrid jsp - Excel and PDF Pin
vsuriyaprakash15-Feb-11 23:15
membervsuriyaprakash15-Feb-11 23:15 
GeneralMy vote of 2 Pin
lester55527-Nov-10 1:09
memberlester55527-Nov-10 1:09 
QuestionIs there a way to Export it without using the Microsoft.Office.Interop.Excel.dll and Microsoft.Office.Interop.Word.dll? Pin
Bigdeak14-Jun-10 5:45
memberBigdeak14-Jun-10 5:45 
Well, i don't thinks it's legal to provide the Excel and Word libraries in a comercial application.
If i use the installed excel version as reference library, i'm not sure if the installed library is compatible with the source code of the ExportToExcel class... and i need excel to be installed.

Isn't there a way to make Excel export from DatagridView possible without use of any office library? Smile | :)
AnswerMessage Closed Pin
16-Aug-10 19:50
memberRyanALEX16-Aug-10 19:50 
AnswerRe: Is there a way to Export it without using the Microsoft.Office.Interop.Excel.dll and Microsoft.Office.Interop.Word.dll? Pin
CikaPero10-Apr-11 23:31
memberCikaPero10-Apr-11 23:31 
QuestionWindows Vista problem ? Pin
Member 152355921-Aug-09 15:24
memberMember 152355921-Aug-09 15:24 
Generalwork with unicode(UT-8) Pin
truong17-Jun-09 22:04
membertruong17-Jun-09 22:04 
QuestionHow to use with MS Office 2003 Pin
Delfy_Coltech24-Mar-09 5:14
memberDelfy_Coltech24-Mar-09 5:14 
AnswerRe: How to use with MS Office 2003 Pin
gg423730-Jul-09 3:22
membergg423730-Jul-09 3:22 
GeneralExcel saves, but no data Pin
bantar7615-Feb-09 17:10
memberbantar7615-Feb-09 17:10 
GeneralRe: Excel saves, but no data Pin
kevinuni15-Feb-09 17:21
memberkevinuni15-Feb-09 17:21 
GeneralRe: Excel saves, but no data Pin
bantar7615-Feb-09 18:32
memberbantar7615-Feb-09 18:32 
GeneralRe: Excel saves, but no data Pin
bantar7616-Feb-09 17:10
memberbantar7616-Feb-09 17:10 
GeneralRe: Excel saves, but no data Pin
akarimov23-Nov-11 6:39
memberakarimov23-Nov-11 6:39 
Generalerror messeage. Pin
Mel Igo4-Jan-09 20:34
memberMel Igo4-Jan-09 20:34 
GeneralRe: error messeage. Pin
kevinuni4-Jan-09 22:29
memberkevinuni4-Jan-09 22:29 
GeneralHelp me! Pin
tiencongaiocon11-Dec-08 23:58
membertiencongaiocon11-Dec-08 23:58 
GeneralRe: Help me! Pin
kevinuni15-Dec-08 10:45
memberkevinuni15-Dec-08 10:45 
Questionunicode support? Pin
Ng. Anh Vu22-Nov-08 6:38
memberNg. Anh Vu22-Nov-08 6:38 
GeneralHi good work Pin
Member 46241699-Nov-08 1:34
memberMember 46241699-Nov-08 1:34 
GeneralRe: Hi good work Pin
kevinuni20-Nov-08 11:19
memberkevinuni20-Nov-08 11:19 
GeneralRe: Hi good work Pin
kevinuni20-Nov-08 11:21
memberkevinuni20-Nov-08 11:21 
GeneralHi Pin
taher khiari28-Oct-08 2:41
membertaher khiari28-Oct-08 2:41 
GeneralRe: Hi Pin
kevinuni29-Oct-08 7:00
memberkevinuni29-Oct-08 7:00 

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

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

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.180111.1 | Last Updated 15 Oct 2008
Article Copyright 2008 by kevinuni
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid