C#打开一个EXCEl文件时如何读取excel文件的表名？

[灵雨飘零]

C#打开一个EXCEL文件时如何读取excel文件的表名？如打开一个EXCEL文件如何读取‘sheet1‘，’sheet2‘。。。的名字？

[feiyun0112]

你怎么打开的？

*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码)

http://feiyun0112.cnblogs.com/

[CutBug]

  string filePath = @"D:\\Excels\test.xls";
            Excel.Application myExcel = new Excel.ApplicationClass();
            object oMissing = System.Reflection.Missing.Value;
            myExcel.Application.Workbooks.Open(filePath, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing);
            Excel.Workbook myBook = myExcel.Workbooks[1];
            for (int i = 0; i < myBook.Worksheets.Count; i++)
            {
                Excel.Worksheet mySheet = (Excel.Worksheet)myBook.Worksheets[i];
                Console.WriteLine(mySheet.Name);
            }

[downmoon]

http://blog.csdn.net/downmoon/archive/2009/01/16/3796652.aspx
http://www.cnblogs.com/downmoon/archive/2009/01/16/1376702.html

[biaofanwo]

读取第一个表的名称
public static string getFirsttableName(string excelFilepath)
{
string tableName = null;
if (File.Exists(excelFilepath))
{
using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet." +
"OLEDB.4.0;Extended Properties=\"Excel 8.0\";Data Source=" + excelFilepath))
{
conn.Open();
DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
tableName = dt.Rows[0][2].ToString().Trim();
}
}
return tableName;
}

[W422080367]

Excel.Worksheet.Name属性

[ahhfclt]

上班了都这么忙呀

[wycoo]

谢谢了啊