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);
}


浙公网安备 33010602011771号