File should have only 1 sheet and no hidden sheets.. And error Message:File contain one more sheets other than specific sheets.
Please reply ASAP
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Goutam PalPosted Apr 29, 2015, 6:21 AM
Sibeesh VenuPosted Apr 29, 2015, 5:26 AM
Please check the links I have shared.
Goutam PalPosted Apr 29, 2015, 5:17 AM
Sibeesh VenuPosted Apr 29, 2015, 5:14 AM
Use
Excel.Workbookand then you can use theWorkbook.Sheets.Count()in afororwhileloop.Please refer here:
http://stackoverflow.com/questions/5080789/how-can-i-determine-how-many-worksheets-there-are-in-an-excel-workbook
http://stackoverflow.com/questions/9275939/get-number-of-sheet-in-xls-excel-file
Please up vote and accept if it helps you.
Kindest Regards
Sibeesh Venu
www.sibeeshpassion.com