/// </summary>
    /// <param name="FilePath">文件路径</param>
    /// <returns>返回这个Excel表的数据集</returns>
    public static DataSet GetDataSet(string FilePath)
    {
        string OledbConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + FilePath + "';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");
        OleDbConnection OleDbconn = new OleDbConnection(OledbConnectionString);
        ArrayList SheetNameList = new ArrayList();
        
        try
        {            if (OleDbconn.State == ConnectionState.Closed)
            {
                
                OleDbconn.Open();                               
            }
            DataTable dtExcelSchema = OleDbconn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            
            string SheetName = "";
            for (int i = 0; i < dtExcelSchema.Rows.Count; i++)
            {
                SheetName = dtExcelSchema.Rows[i]["TABLE_NAME"].ToString();
                SheetNameList.Add(SheetName);
                
            }        }
        catch (Exception ex)
        {            string testsql4 = string.Format("insert into Table_test_ch(Num,NeiRong)values(751,'{0}')", ex.Message);
            int testnum4 = DbManager.Static_excuteNonQuerySqlCount(testsql4); 
        }
        finally
        {
            OleDbconn.Close();
        }
        DataSet dsExcel = new DataSet();        try
        {
            string strSql = "";            for (int i = 0; i < SheetNameList.Count; i++)
            {
                strSql = "select* from [" + (string)SheetNameList[i] + "]";
                OleDbDataAdapter oleExcelDataAdapter = new OleDbDataAdapter(strSql, OleDbconn);
                DataTable dtExcel = new DataTable((string)SheetNameList[i]);
                oleExcelDataAdapter.Fill(dtExcel);
                dsExcel.Tables.Add(dtExcel);
            }
            return dsExcel;
        }
        catch (Exception ex)
        {
            
            throw ex;
        }
    }我用了一个方法 读取Excel放到dataset里面本地可以用 我发布网站放到服务器上 就没法用
主要错误是在服务器上没法打开OleDbConnection这个
求解????