获取Excel的sheet名称和数量

最新推荐文章于 2024-06-24 08:40:14 发布

weixin_34191734

最新推荐文章于 2024-06-24 08:40:14 发布

阅读量686

点赞数

文章标签： javascript php ViewUI

原文链接：http://www.cnblogs.com/umlzhang/archive/2009/05/12/1455013.html

版权

string name=sheet.Name; //获取该sheet的名称
   string amount=book.WorkSheets.Count.ToString(); //获取该book的sheet数量。
     string sSheetName=null;
     object missing = Missing.Value;
      OleDbConnection conn = new OleDbConnection();
      Excel.Application excelApp = new Excel.Application();
     excelApp.Application.Workbooks.Open(path, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,Missing.Value ,Missing.Value,Missing.Value,Missing.Value ,Missing.Value ,Missing.Value );
       for (int i = 0; i < excelApp.Workbooks[1].Worksheets.Count; i++)
        {
          Excel.Worksheet ws = (Excel.Worksheet)excelApp.Workbooks[1].Worksheets[1];
          sSheetName = ws.Name;
        }

转载于:https://www.cnblogs.com/umlzhang/archive/2009/05/12/1455013.html