title: How to Save excel file in vb.net
body: <p>Previously , I was trying to export gridview value into excel. but with the code given below i am able to export data into excel. but still not able to <strong>Save Automatically</strong> that excel file into a <strong>fixed folder suppose in C:/ drive</strong>. The code which i have written to export into excel is given below.</p>
  
  <pre><code>Private Sub ButtonExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)   Handles ButtonExport.Click
  Dim rowsTotal, colsTotal As Short
  Dim I, j, iC As Short
  System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
  Dim xlApp As New Excel.Application
  Try
      Dim excelBook As Excel.Workbook = xlApp.Workbooks.Add
      Dim excelWorksheet As Excel.Worksheet = CType(excelBook.Worksheets(1), Excel.Worksheet)
      xlApp.Visible = True
      rowsTotal = DataGridView1.RowCount - 1
      colsTotal = DataGridView1.Columns.Count - 1
      With excelWorksheet
          .Cells.Select()
          .Cells.Delete()
          For iC = 0 To colsTotal
              .Cells(1, iC + 1).Value = DataGridView1.Columns(iC).HeaderText
          Next
          For I = 0 To rowsTotal - 1
              For j = 0 To colsTotal
                  .Cells(I + 2, j + 1).value = DataGrid1.Rows(I).Cells(j).Value
              Next j
          Next I
          .Rows("1:1").Font.FontStyle = "Bold"
          .Rows("1:1").Font.Size = 10
          .Cells.Columns.AutoFit()
          .Cells.Select()
          .Cells.EntireColumn.AutoFit()
          .Cells(1, 1).Select()
      End With
  Catch ex As Exception
      MsgBox("Export Excel Error " &amp; ex.Message)
  Finally
      'RELEASE ALLOACTED RESOURCES
      System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default
      xlApp = Nothing
  End Try
  End Sub
  </code></pre>
  
  <p>can anybody over here please help me out from this problem that how to save that excel file automatically in VB.NET??</p>