C#中获取Excel文件的表名

public static string GetExcelFirstTableName(string excelFileName)
{
    
string tableName = null;
    
if (File.Exists(excelFileName))
    
{
        
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet."+
                    
"OLEDB.4.0;Extended Properties=\"Excel 8.0\";Data Source=" + excelFileName))
        
{
            conn.Open();
            DataTable dt 
= conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
            
for(int i=0;i<dt.Rows.Count;i++)
            
{
                tableName
+=dt.Rows[i][2].ToString().Trim()+";";
            }

        }

    }

    
return RemoveTail(tableName);
}

posted on 2006-06-23 10:08  ★金★  阅读(1696)  评论(3编辑  收藏  举报

导航