How to Export datagridview to Excel

The DataGridView control serves as a versatile and customizable table that facilitates the display of data in a structured and tabular format. The need to present data in a tabular manner arises frequently in various software applications and systems.

One of the notable strengths of the DataGridView control lies in its high level of configurability and extensibility. It offers a wide range of properties, methods, and events that empower developers to tailor its appearance and behavior according to specific requirements and preferences. These comprehensive customization options enable developers to create visually appealing and user-friendly interfaces that effectively present data to users.

With the DataGridView control, you have the ability to define and fine-tune various aspects of its presentation and functionality. You can modify properties such as cell styles, column layout, row behavior, and interaction behaviors. This allows you to adapt the control to match the visual design and functional requirements of your application.

Export the content of a datagridview to an Excel file

The following vb.net source code shows how to Export the content of a datagridview to an Excel file.

Full Source VB.NET
Imports System.Data.SqlClient Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connectionString As String = "Data Source=.;Initial Catalog=pubs;Integrated Security=True" Dim sql As String = "SELECT * FROM Authors" Dim connection As New SqlConnection(connectionString) Dim dataadapter As New SqlDataAdapter(sql, connection) Dim ds As New DataSet() connection.Open() dataadapter.Fill(ds, "Authors_table") connection.Close() DataGridView1.DataSource = ds DataGridView1.DataMember = "Authors_table" End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim xlApp As Excel.Application Dim xlWorkBook As Excel.Workbook Dim xlWorkSheet As Excel.Worksheet Dim misValue As Object = System.Reflection.Missing.Value Dim i As Int16, j As Int16 xlApp = New Excel.ApplicationClass xlWorkBook = xlApp.Workbooks.Add(misValue) xlWorkSheet = xlWorkBook.Sheets("sheet1") For i = 0 To DataGridView1.RowCount - 2 For j = 0 To DataGridView1.ColumnCount - 1 xlWorkSheet.Cells(i + 1, j + 1) = DataGridView1(j, i).Value.ToString() Next Next xlWorkBook.SaveAs("c:\vb.net-informations.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, _ Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue) xlWorkBook.Close(True, misValue, misValue) xlApp.Quit() releaseObject(xlWorkSheet) releaseObject(xlWorkBook) releaseObject(xlApp) MessageBox.Show("Over") End Sub Private Sub releaseObject(ByVal obj As Object) Try System.Runtime.InteropServices.Marshal.ReleaseComObject(obj) obj = Nothing Catch ex As Exception obj = Nothing MessageBox.Show("Exception Occured while releasing object " + ex.ToString()) Finally GC.Collect() End Try End Sub End Class





Related Topics
  1. VB.NET DataGridView binding - Sql Server
  2. DataGridView binding - OLEDB in VB.NET
  3. DataGridView Sorting/Filtering in VB.NET
  4. DataGridView adding rows and columns in VB.NET
  1. DataGridView hiding rows and columns in VB.NET
  2. DataGridView ReadOnly rows and columns in VB.NET
  3. Adding Button to DataGridView in VB.NET
  4. Adding CheckBox to DataGridView in VB.NET
  5. Adding ComboBox to DataGridView in VB.NET
  6. Adding Image to DataGridView in VB.NET
  7. Adding ViewLink to DataGridView in VB.NET
  8. How to Paging in DataGridView
  9. How to Formatting in DataGridView
  10. How to DataGridView Template
  11. How to DataGridView Printing in VB.Net
  12. How to Import data from Excel to DataGridView
  13. Database operations in DatagridView
  14. Delete row from datagridview by Right click
  15. DataGridView Autocomplete TextBox in VB.Net