QI.Text = ValQI.ToString
' VERSION 4.1.1.8 Imports System.Windows.Forms Imports OXL = Microsoft.Office.Interop.Excel Imports System.IO Imports System.Data.OleDb Imports System.Drawing.Drawing2D Imports System.Math Imports System Imports System.Net Imports System.Text Public Class Visiondeloin Dim resolution As Boolean Dim erreur As Boolean Public ValFlap As Double Public ValRSB As Double Public valDELTAS As Double Dim ValPACHY As String Public ValAXE As Integer Public ValAD As Integer Dim ValAL As Integer Public ValST As Double Public ValCT As Double Dim ValAT As String Dim ValATL As String Public ValADP As Integer Public ValSIMAGE2 As Double Public ValCIMAGE2 As Double Public ValAXEIMAGE2 As Integer Public ValSIMAGE2P As Double Public ValSIMAGE3 As Double Public ValCIMAGE3 As Double Public ValAXEIMAGE3 As Double Public ValS As Double Public ValC As Double Public ValSC As Double Public ValCC As Double Public ValK1 As Double Public ValK2 As Double Public ValQI As Double Public ValAC As Integer Public ValSE As Double Public ValSED As Double Public valUOZMIN As Double Public valUOZMEAN As Double Public valUOZMAX As Double Public ValPupilphoto As Integer Public ValPupilmeso As Integer Public ValPupilmax As Integer Public ValACD As Double Public valCTHICKNESS As Integer Public VALDVA As Double Public VALADD As Double Public VALNVA As Double Public VALDVA2 As Double Public VALADD2 As Double Public VALNVA2 As Double Public VALOZ As Double Public VALversion As Double Public valrotate As Integer Public VALA As Double Public VALA1 As Double Public valverifTS As Double Public VALQL As Double Public VALTSA As Double Public VALKPF As Double Public VALKCF As Double Public VALKPI As Double Public VALQILEFT As Double Public VALQIRIGHT As Double Public valTxtpseudo As String Public valTxtrelift As String Public valTxtcat As String Public VALdeltaqi As Double Public AppExcel As OXL.Application Public VALaddage As Double Public VALqfref As Double Private xlWorkbook As OXL.Workbook 'feuille 1 Private xlWorkSheetOne As OXL.Worksheet
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionQILEFT = -1.14 QIRIGHT = -0.59
Private Sub Buttonload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Buttonload.Click ' Fichier Excel Dim CheminFicher As String Dim BoiteDialogue As New OpenFileDialog txtDocteur2.Text = txtDocteur.Text If AppExcel IsNot Nothing Then MessageBox.Show("Excel Worksheet is closing please wait") If xlWorkSheetOne IsNot Nothing Then xlWorkSheetOne = Nothing End If If xlWorkbook IsNot Nothing Then xlWorkbook.Close() xlWorkbook = Nothing End If AppExcel.Quit() AppExcel = Nothing End If With BoiteDialogue ' Initialisation de la boite de dialogue .Title = "Load Data" .InitialDirectory = "\D:\encours\" .Filter = "Fichiers Excel |*.xls; *.xlsx" ' vérification de la séléction If .ShowDialog() = System.Windows.Forms.DialogResult.OK Then CheminFicher = .FileName Else MessageBox.Show("Aucun fichier Excel séléctionné") Exit Sub ' Abandon de la routine End If 'ouvre l'onglet 1 de l'application AppExcel = New OXL.Application xlWorkbook = AppExcel.Workbooks.Open(CheminFicher) xlWorkSheetOne = CType(xlWorkbook.Worksheets(1), Microsoft.Office.Interop.Excel.Worksheet) AppExcel.Visible = False 'chargement des data en Textbox Dim rng As OXL.Range = Nothing . . rng = CType(Me.xlWorkSheetOne.Cells(16, 15), Microsoft.Office.Interop.Excel.Range) Me.K2.Text = CType(rng.Value, String) rng = CType(Me.xlWorkSheetOne.Cells(22, 2), Microsoft.Office.Interop.Excel.Range) Me.QIRIGHT.Text = CType(rng.Value, String) rng = CType(Me.xlWorkSheetOne.Cells(22, 10), Microsoft.Office.Interop.Excel.Range) Me.QILEFT.Text = CType(rng.Value, String) . .
Me.QIRIGHT.Text = CType(rng.Value, String)
Private Sub Buttonload_Click( ..... blabla calculqi end sub
VALQILEFT = CDbl(Me.QILEFT.Text.Replace(".", ",")) VALQIRIGHT = CDbl(Me.QIRIGHT.Text.Replace(".", ","))