求讀取Excel的方法(從其中的第几列開始讀)?
ggygd 2006-04-19 11:41:47 Dim myOleDbConnection As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\test.xls;" & _
"Extended Properties=""Excel 8.0;""")
Dim myOleDbCommand As OleDbCommand = New OleDbCommand("SELECT *
FROM [Sheet1$]",myOleDbConnection)
Dim myData As OledbDataAdapter= New
OledbDataAdapter(myOleDbCommand)
如果我要從excel(Sheet1)的A3行開始讀,怎樣實現? 謝謝