代码如下:
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Dim MyConnection As System.Data.OleDb.OleDbConnectionMyConnection = New System.Data.OleDb.OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=C:\myData.XLS; " & _
"Extended Properties=Excel 8.0;")
' Select the data from Sheet1 of the workbook.
MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [Sheet1$]", MyConnection)DS = New System.Data.DataSet()
MyCommand.Fill(DS)
DataGrid1.DataSource = DtSet.Tables(0)
excel的内容如下:11 11 11 11
22 22 22 22
aa aa aa aa
33 33 33 33
可是通过datagride显示的时候确变成了11 11 11 11
22 22 22 22
null null null null
33 33 33 33请问这是为什么呀???
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Dim MyConnection As System.Data.OleDb.OleDbConnectionMyConnection = New System.Data.OleDb.OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=C:\myData.XLS; " & _
"Extended Properties=Excel 8.0;")
' Select the data from Sheet1 of the workbook.
MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [Sheet1$]", MyConnection)DS = New System.Data.DataSet()
MyCommand.Fill(DS)
DataGrid1.DataSource = DtSet.Tables(0)
excel的内容如下:11 11 11 11
22 22 22 22
aa aa aa aa
33 33 33 33
可是通过datagride显示的时候确变成了11 11 11 11
22 22 22 22
null null null null
33 33 33 33请问这是为什么呀???
解决方案 »
- 奇怪,为什么我在程序中加了热键的功能,MediaPlayer就不能连续播放了
- Winsock文件传输!!!
- 数据查询真是难得搞懂,郁闷啊,散分!
- 关于frame控件,怎样将在frame控件之前生成的控件放入frame中呢?
- vb2008 界面设计
- 在不用现成的DB管理工具(如Access)的情况下,如何利用VB实现高效的数据存储管理
- 高分! 但是不知道是不是简单。。。 关于Excel中焦点的问题。发言有分!
- VB6。0的"多步OLE DB操作产生错误",求解!
- 很简单的SQL问题,送分!~
- 我想做一个平滑的进度条,但我怎么也实现不了在其中显示的文字(如78%)能够一半白色而另一半蓝色,而且是在每个字在都要实现这种效果,怎么办,我用的是textout的API函数
- 关于SQL的子查询问题,高手请进
- vbs如何使用模拟键盘
Dim xls As Object
Set xls = CreateObject("excel.application")
xls.Workbooks.Open "c:\test.xls"
xls.Visible = True
Dim i As Long
Dim j As Long
With xls.Workbooks(1).Sheets("Sheet1")
For i = 1 To .UsedRange.Rows.Count
For j = 1 To .UsedRange.Columns.Count
.Cells(i, j) = "'" & .Cells(i, j)
Next
Next
End With
xls.DisplayAlerts = False
xls.ActiveWorkbook.Save
xls.Quit
Set xls = Nothing
End Sub......