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