title: Export more than 2000 row of data from a data gridview to excel file in vb.net
body: <p>I did succeed to export data from a DataGridView to excel file by using a loop and writing cell by cell, but the problem is i have more than 2000 rows so the exporting process takes a lot of time.
  My question is : Is there anything to change so i can minimize the exportation time ?
  Thanks</p>
  
  <pre><code>'exporter
  Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
      Dim xlApp As Excel.Application
      Dim xlBook As Excel.Workbook
      Dim xlSheet As Excel.Worksheet
      xlApp = New Excel.Application
      xlBook = xlApp.Workbooks.Open(Filename:=Path.Combine(Application.StartupPath, "EMP_.xlsx"), IgnoreReadOnlyRecommended:=True, ReadOnly:=False, Editable:=True)
      xlSheet = xlBook.Worksheets(1)
      If DataGridView1.DataSource IsNot Nothing Then
          Dim i, j As Integer
          For i = 1 To DataGridView1.RowCount - 1
              For j = 1 To DataGridView1.ColumnCount
                  xlSheet.Cells(i + 1, j) = DataGridView1.Rows(i - 1).Cells(j - 1).Value
              Next
          Next
          xlApp.Visible = True
          xlApp.UserControl = True
          xlApp.Quit()
          xlApp = Nothing
      Else
          MsgBox("Le tableau est vide")
      End If
  End Sub
  </code></pre>