C#获取Excel中所有的Sheet名称

最新推荐文章于 2024-10-21 11:48:53 发布

转载最新推荐文章于 2024-10-21 11:48:53 发布 · 1.3k 阅读

文章标签：

#excel #c# #string #properties #object #null

本文介绍如何使用C#代码打开Excel文件并获取其中的所有Sheet名称。通过创建Excel应用程序对象，并利用OLE DB连接来获取Excel文件内的Sheet信息。

源：http://blog.youkuaiyun.com/qq1010726055/article/details/6858849

Excel.Application myExcel = new Excel.Application();
object missing = System.Reflection.Missing.Value;
myExcel.Application.Workbooks.Open(this.txtFile.Text, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);//this.txtFile.Text为Excel文件的全路径
Excel.Workbook myBook = myExcel.Workbooks[1];

//获取第一个Sheet
Excel.Worksheet sheet = (Excel.Worksheet)myBook.Sheets[1];　
string sheetName = sheet.Name; //Sheet名

//获取全部Sheet名

public static StringCollection ExcelSheetName(string filepath)
{
StringCollection names = new StringCollection();
string strConn;
strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=2'";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataTable sheetNames = conn.GetOleDbSchemaTable
(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
conn.Close();

foreach (DataRow dr in sheetNames.Rows)
{
names.Add(dr[2].ToString());
}
return names;
}