Is it possible to load Excel sheets' name into MATLAB by using 'xlsread'?

Question

I have 10 Excel files with 50 sheets in each, every sheet has a different name. I want load all sheets' names into MATLAB, put them into a cell string. Is it possible to 'xlsread' command to do this? Or is there other ways?

Thanks!

Answer 1

You can use xlsfinfo to get a list of sheet names in an excel file.

[status,sheets] = xlsfinfo(filename) 

The variable sheets will contain a cell array with the sheet names.