请教，怎么连接Excel文件，读取里面的数据

Question

连接字符串怎么写。能不能像操作mdb文件，那样操作xls文件呢

Answer 1

strConn   =   "Provider=Microsoft.Jet.OLEDB.4.0;"   +   
  "Data   Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+   
  "Extended   Properties=Excel   8.0;";   
  OleDbConnection   conn   =   new   OleDbConnection(strConn);   
  OleDbDataAdapter   myCommand   =   new   OleDbDataAdapter("SELECT   *   FROM   [Sheet1$]",   strConn);   
  DataSet   myDataSet   =   new   DataSet();   
  myCommand.Fill(myDataSet);   

Answer 2

  Dim sql As String
                        Dim strConn As String
                        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strUpFile + ";" + "Extended Properties=Excel 8.0;"
                        Dim conn As OleDbConnection
                        conn = New OleDbConnection(strConn)
                        conn.Open()
                        Dim schemaTable As DataTable
                        schemaTable = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, Nothing)
                        Dim tableName As String
                        tableName = schemaTable.Rows(0)(2).ToString().Trim()
                        sql = "SELECT * FROM [" & tableName & "]"
                        Dim myCommand As OleDbDataAdapter = New OleDbDataAdapter(sql, conn)
                        Dim ds As DataSet = New DataSet
                        myCommand.Fill(ds, "table1")
                        If ds.Tables("table1").Rows.Count > 0 Then
                            Dim dt As New DataTable
                            Dim row As DataRow
                            dt = ds.Tables("table1")
                           ... ... .                 
                         End If

Answer 3

connString = ExcelOperation.GetExcelConnection(ExcelFileName);// 或者"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFileName + ";Extended Properties=Excel 8.0;"; http://blog.csdn.net/jjjjj102310253/archive/2008/11/25/3370346.aspx