我用以下的程序读取Excel文件的sheet name.
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("../Upload") + @"\" + userName + @".xls;Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""";
objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);            if (dt == null)
            {
                return null;
            }            String[] excelSheets = new String[dt.Rows.Count];
            int i = 0;            // Add the sheet name to the string array.
            foreach (DataRow row in dt.Rows)
            {
                string tableName = row["TABLE_NAME"].ToString();
                string[] t = tableName.Split('$');
                if (t[0].Contains("'"))
                {                    t[0] = t[0].Substring(1);
                }
                excelSheets[i] = t[0];
                i++;            }读取后把B2.2.1变成了B2#2#1了,请问解决呢?