110,538
社区成员
发帖
与我相关
我的任务
分享
//得到Excel表名
public static DataTable GetName(string path)
{
string strPath = path;
if (!strPath.EndsWith(".xls"))
{
return null;
}
OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + strPath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'");
OleDbCommand ExcelCommand = new OleDbCommand();
ExcelCommand.Connection = ExcelConnection;
OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);
ExcelConnection.Open();
DataTable ExcelSheets = ExcelConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
ExcelConnection.Close();
return ExcelSheets;
}