Come faccio a recuperari dati inseriti in alcune celle o intervalli di celle posti in fogli diversi di uno stesso file excel da vb.net?
Ho provato con un reader, ma mi genera un sacco di errori...
Non capisco...
Private Function RetrieveDate() As Date
Dim MyConn As New OleDb.OleDbConnection
Dim dateReader As OleDb.OleDbDataReader
Dim MyConnString As String
Dim MyCmd As New OleDb.OleDbCommand
Try
MyConnString = "Data Source=" & sNewFile & ";Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Extended Properties=Excel 8.0;"
MyConn.ConnectionString = MyConnString
MyConn.Open()
MyCmd.Connection = MyConn
' MyCmd.CommandText = "SELECT * FROM [Menu$]"
MyCmd.CommandText = "SELECT * FROM [Sheet1$]"
MyCmd.ExecuteReader()
Try
While (dateReader.Read)
txtDate.Text = dateReader.GetDateTime(4)
End While
Finally
dateReader.Close()
End Try
Catch ex As Exception
' MsgBox(ex.Message, MsgBoxStyle.Critical + MsgBoxStyle.OKOnly)
txtDate.Text = ex.Message
End Try
End Function
Mi dice che
Object reference not set to an instance of an object.
Sulla riga
While (dateReader.Read)
Grazie 1000
Rispondi quotando
