Count worksheets in an excel workbook without using xlsfinfo

12 次查看（过去 30 天）
Michael Horn
Michael Horn 2021-4-23
回答： Harsh 2021-4-26
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

请先登录，再回答此问题。

采纳的回答

Harsh
Harsh 2021-4-26
You can use sheetnames.
>> sheets = sheetnames('patients.xls')
sheets =
3×1 string array
"Sheet1"
"Sheet2"
"Sheet3"
>> numel(sheets)
ans =
3

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by