如何从Excel工作表中读取数据 [英] How Do I Read The Data From Excel Sheet

问题描述

  Dim  ExcelConnection  As  System.Data.OleDb.OleDbConnection 
  Dim  ExcelCommand  As  System.Data.OleDb.OleDbDataAdapter 
 ExcelConnection = 新 System.Data.OleDb.OleDbConnection（  provider = Microsoft.Jet .OLEDB.4.0;&   data source = + txtExcelPath.Text +  ;扩展属性= Excel 8.0;）
 
 ExcelConnection.Open（ ）
 ExcelCommand = 新 System.Data.OleDb.OleDbDataAdapter（  select * from [Sheet1 $]，ExcelConnection）
 
  Dim  ds 作为 新 DataSet 
 ExcelCommand.Fill（ds）
 ExcelConnection。关闭（）

这是我的代码，但ExcelConnection.Open（）中有错误。错误是外部表不是以预期的格式。我的Excel工作表格式为.xlsx请帮助我

提前感谢

解决方案

， ExcelConnection）

Dim ds As 新 DataSet
ExcelCommand.Fill（ds）
ExcelConnection.Close（）

this是我的代码，但ExcelConnection.Open（）中有一个错误。错误是外部表不是预期的格式。我的Excel表格格式为.xlsx请帮助我

提前感谢

我不认为JET可以读取新的Excel文件。请尝试使用ACE：



http://www.microsoft.com/en-us/download/details.aspx?id=13255 [ ^ ]

参见 http://www.connectionstrings.com/excel-2010/ [ ^ ]



更改

 ExcelConnection = New System.Data.OleDb.OleDbConnection （  provider = Microsoft.Jet.OLEDB.4.0;&   data source = + txtExcelPath.Text +  ;扩展属性= Excel 8.0;）

到

 ExcelConnection =新S ystem.Data.OleDb.OleDbConnection（Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ txtExcelPath.Text +; Extended Properties ='Excel 12.0 Xml; HDR = YES'）

Dim ExcelConnection As System.Data.OleDb.OleDbConnection
       Dim ExcelCommand As System.Data.OleDb.OleDbDataAdapter
       ExcelConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" & "data source=" + txtExcelPath.Text + ";Extended Properties=Excel 8.0;")
       
       ExcelConnection.Open()
       ExcelCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", ExcelConnection)

       Dim ds As New DataSet
       ExcelCommand.Fill(ds)
       ExcelConnection.Close()

this is my code but there is an error in ExcelConnection.Open().The error was "External table is not in the expected format".My Excel sheet format is .xlsx please help me
thanks in advance

解决方案

", ExcelConnection) Dim ds As New DataSet ExcelCommand.Fill(ds) ExcelConnection.Close()

this is my code but there is an error in ExcelConnection.Open().The error was "External table is not in the expected format".My Excel sheet format is .xlsx please help me
thanks in advance

I don't think JET can read the new Excel files. Try ACE instead:

http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]

See http://www.connectionstrings.com/excel-2010/[^]

Change

ExcelConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;" & "data source=" + txtExcelPath.Text + ";Extended Properties=Excel 8.0;")

to

ExcelConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + txtExcelPath.Text + ";Extended Properties='Excel 12.0 Xml;HDR=YES'")

这篇关于如何从Excel工作表中读取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！