Click here to Skip to main content
15,038,237 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Is there a simple and easier way of counting the number of sheets in a excel file.Any Codes or function

Thanks
Posted

How sbout MyExcelApp.WorkBook.Sheets.Count ?
   
You can Use EPPLUS library For Reading Excel.

using (var package = new ExcelPackage(existingFile))
{
MemoryStream stream = new MemoryStream();

int no_of_sheet= package.Workbook.worksheets.count;

}
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900