秒客网

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