Imports Excels = Microsoft.Office.Interop.Excel Dim xlApp As Excels.Application Dim xlWorkBook As Excels.Workbook Dim xlWorkSheet As New Excels.Worksheet Dim misValue As Object = System.Reflection.Missing.Value xlApp = New Excels.ApplicationClass xlWorkBook = xlApp.Workbooks.Add(misValue) xlWorkSheet = xlWorkBook.Sheets("sheet1")
Dim fichier As String fichier = "d:\Nom-Fichier" & Format(Now(), "yyyy-MM-dd") & ".xlsx" xlWorkSheet.SaveAs(fichier) xlApp.Application.Quit()
Dim ch As String Dim SaveFileDialog1 As New SaveFileDialog() Dim result As DialogResult = SaveFileDialog1.ShowDialog() If (result = Windows.Forms.DialogResult.OK) Then ch = SaveFileDialog1.FileName xlWorkSheet.SaveAs(ch) xlApp.Application.Quit() End If
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim xlWorkSheet As New Excel.Worksheet