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:
Yes, it is possible to load the names of Excel sheets into MATLAB by using the 'xlsread' function. The 'xlsread' function can be used to read the data in an Excel spreadsheet and also to extract information about the sheets in the workbook, including the sheet names.
To load the sheet names, you can use the following syntax:
[~,sheets] = xlsfinfo(fileName);
Where 'fileName' is the name of the Excel file that you want to read and 'sheets' is a cell array that will contain the names of the sheets.
You can then use a for loop to iterate through the 'sheets' array and access each sheet by its name. For example, to read the data in the first sheet, you can use the following syntax:
data = xlsread(fileName, sheets{1});
And to read the data in the second sheet, you can use:
data = xlsread(fileName, sheets{2});
In this way, you can easily read data from multiple sheets in an Excel workbook by using the 'xlsread' function and the sheet names.
It's worth noting that xlsread is a legacy function and it's not recommended to use it, instead, it's better to use MATLAB's Spreadsheet Interface, which is a more modern way of reading and writing data to and from spreadsheet files, it support both xls and xlsx files and also it can read and write data to the sheet by the sheet name, the syntax is similar to xlsread, but more powerful.
In summary, it is possible to load the sheet names of an Excel file into MATLAB using the 'xlsread' function, and then use the sheet names to read data from the specific sheets in the workbook. However, it's recommended to use the Spreadsheet Interface for better performance and more functionality.
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.