Torna al Thread

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles PassaExcel.Click Dim xlApp As Microsoft.Office.Interop.Excel.Application ' Riferimento all'applicazione Excel Dim xlBook As Microsoft.Office.Interop.Excel.Workbook ' Riferimento al Workbook Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet ' Riferimento al Worksheet Dim strqta As String Dim strpzz As String Dim NumQta As Double Dim numPzz As Double Dim importo As Double xlApp = New Microsoft.Office.Interop.Excel.ApplicationClass xlBook = xlApp.Workbooks.Open(Me.ExcelFilePath) xlSheet = xlBook.Worksheets("PREVENTIVO") xlSheet.Activate() xlSheet.Range("RS").Value = Rag xlSheet.Range("INDIRIZZO").Value = Ind xlSheet.Range("CAP").Value = CapC xlSheet.Range("CITTA").Value = Loc xlSheet.Range("PR").Value = Prov xlSheet.Range("TIPDOC").Value = "ORDINE" xlSheet.Range("DP").Value = Pagam xlSheet.Range("DESBAN").Value = Banca xlSheet.Range("DTDOC").Value = Date.Today xlSheet.Range("ISO").Value = Iso xlSheet.Range("CF").Value = Piva xlSheet.Range("CP").Value = "01" For iRow As Integer = 0 To Me.dgvCarrello.RowCount - 1 xlSheet.Range("DESART").Item(iRow + 1, 1) = dgvCarrello.Item(0, iRow).Value Next For iRow As Integer = 0 To Me.dgvCarrello.RowCount - 1 xlSheet.Range("QTA").Item(iRow + 1, 1) = dgvCarrello.Item(1, iRow).Value Next For iRow As Integer = 0 To Me.dgvCarrello.RowCount - 1 xlSheet.Range("UM").Item(iRow + 1, 1) = dgvCarrello.Item(4, iRow).Value Next For iRow As Integer = 0 To Me.dgvCarrello.RowCount - 1 xlSheet.Range("PZZ").Item(iRow + 1, 1) = dgvCarrello.Item(5, iRow).Value Next For iRow As Integer = 0 To Me.dgvCarrello.RowCount - 1 strqta = dgvCarrello.Item(1, iRow).Value strpzz = dgvCarrello.Item(5, iRow).Value NumQta = Convert.ToDouble(strqta) numPzz = Convert.ToDouble(strpzz) importo = NumQta * numPzz xlSheet.Range("IMPORTO").Item(iRow + 1, 1) = importo <---- |Questo campo non viene scritto| Next xlBook.Close(True) xlSheet = Nothing xlBook = Nothing xlApp = Nothing End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5