获取execl中所有的sheet名字

        private static List<string> GetExcelSheetNames(string filePath)
        {
            List<string> names = new List<string>();
            Microsoft.Office.Interop.Excel.Application excelApp = null;
            object missing = System.Reflection.Missing.Value;
            try
            {
                excelApp = new Microsoft.Office.Interop.Excel.Application();
                Microsoft.Office.Interop.Excel.Workbooks wbs = excelApp.Workbooks;
                Microsoft.Office.Interop.Excel.Workbook wb = wbs.Open(filePath, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                Type.Missing, Type.Missing, Type.Missing, Type.Missing);
                int count = wb.Worksheets.Count;
                for (int i = 1; i <= count; i++)
                    names.Add(((Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[i]).Name);
                wb.Close(missing, missing, missing);
                wb = null;
                excelApp.Quit();
            }
            catch
            {
                excelApp.Quit();
            }
            return names;
        }

posted on 2013-10-12 16:25  习惯简单  阅读(1325)  评论(0编辑  收藏  举报

导航