how to get total number of sheet in a excel file using c#

Question

pls tell me how to get total number of sheet available in excel file using c#

Amit Thorat · Answer

You can use Excel.Workbook and for count Workbook.Sheets.Count() in a for or while loop.