Count worksheets in an excel workbook without using xlsfinfo

I have excel workbooks with multiple worksheets that I want to read in.

Is there a function besides xlsfinfo that will count the number of worksheets?

I can explain why xlsfinfo doesn't work, if anyone needs to know, but it is beside the point. The short answer is that it returns a character variable if it encounters an issue inspecting the workbook. The same issue creates no problem for readtable. So I can get my data, but I need to find a way of telling my loop how many worksheets to look for.

Thanks

Answer 1

[Harsh]

You can use sheetnames.

>> sheets = sheetnames('patients.xls')

sheets = 

  3×1 string array

    "Sheet1"
    "Sheet2"
    "Sheet3"
    
>> numel(sheets)

ans =

     3