java得到excel所有的sheet名_获取execl中所有的sheet名字

private static List GetExcelSheetNames(string filePath)

{

List names = new List();

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;

}