dataset读取excel数据列唯其如此读入164列
dataset读取excel数据列只能读入164列
Dim ds As New DataSet()
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & excelFile & ";" & "Extended Properties=Excel 8.0;"
Dim conn As New OleDbConnection(strConn)
conn.Open()
Dim strExcel As String = ""
Dim myCommand As OleDbDataAdapter = Nothing
strExcel = String.Format("select * from [{0}${1}]", sheetName, strField)
myCommand = New OleDbDataAdapter(strExcel, strConn)
myCommand.Fill(ds, sheetName)
真是怪事啦 excel 有200多列
进入调试--监视 ds.Tables(0).Columns.Count =164
后面的列没有读取
------解决方案--------------------
excel是什么版本,2007的试试 "Provider=Microsoft.ace.OLEDB.12.0;"
------解决方案--------------------
按理不会这样,是你excel里数据有什么问题,将ds里数据放到datagridview里看看,
Dim ds As New DataSet()
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & excelFile & ";" & "Extended Properties=Excel 8.0;"
Dim conn As New OleDbConnection(strConn)
conn.Open()
Dim strExcel As String = ""
Dim myCommand As OleDbDataAdapter = Nothing
strExcel = String.Format("select * from [{0}${1}]", sheetName, strField)
myCommand = New OleDbDataAdapter(strExcel, strConn)
myCommand.Fill(ds, sheetName)
真是怪事啦 excel 有200多列
进入调试--监视 ds.Tables(0).Columns.Count =164
后面的列没有读取
------解决方案--------------------
excel是什么版本,2007的试试 "Provider=Microsoft.ace.OLEDB.12.0;"
------解决方案--------------------
按理不会这样,是你excel里数据有什么问题,将ds里数据放到datagridview里看看,