C#获取Excel里sheet名，其表内容

public static DataTable GetExcelTable(string excelFilename)  

{  

    string connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Jet OLEDB:Engine Type=35;Extended Properties=Excel 8.0;Persist Security Info=False",excelFilename);  

    DataSet ds = new DataSet();  

    string tableName;  

    using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(connectionString))  

    {  

        connection.Open();  

        DataTable table = connection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);  

        tableName = table.Rows[0]["Table_Name"].ToString();  

        string strExcel = "select * from " + "[" + tableName + "]";  

        OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, connectionString);  

        adapter.Fill(ds, tableName);  

        connection.Close();  

    }  

    return ds.Tables[tableName];  

}

  //VB Code

    Dim connectionString As String ' Used to store the connection string

    Dim customerList As New DataSet ' Used to store the temp records readed from the Excel file

    Dim excelData As OleDb.OleDbDataAdapter

 

    connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;HDR=YES"";", fileName)

    excelData = New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString)

    excelData.TableMappings.Add("Sheet1", "ImportCustomer")

excelData.Fill(customerList)