I have 10 excel files with 50 sheets in each, each sheet has a different name. I want to load the names of all sheets in MATLAB, put them in the row of the cell. Is it possible to execute the "xlsread" command? Or are there other ways?
Thank!
You can use xlsfinfoto get a list of sheet names in an excel file.
xlsfinfo
[status,sheets] = xlsfinfo(filename)
Variable sheets will contain an array of cells with sheet names.