How to import data from multiple worksheets contained in 1 workbook?

Hi,

I have a workbook SelfStorageData.xls . It contains 3 worksheets . I want to import data from each of these 3 worksheets as 3 different matrices. Here is my code:

T = readtable('SelfStorageData.xls');

However, I get the following error:

Unable to open file 'SelfStorageData.xls' as a workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file.

How can this be fixed? Excel Workbook attached.

Answer 1

[Monalisa Pal]

You may use the importdata function instead to fetch data in matrix but seeing that you have some non-numeric data, I wouldn't recommend it.

T = importdata('SelfStorageData.xlsx');

Then use variable names to access the individual matrices:

T1 = T.data.ExampleLeases;
T2 = T.data.TypicalMoveIn;
T3 = T.data.TypicalMoveOut;

Alternatively, you may look into https://www.mathworks.com/help/matlab/ref/matlab.io.spreadsheet.spreadsheetimportoptions.html

So, if you need to use the readtable function, you might do something like this. It's much more flexible.

T1 = readtable('SelfStorageData.xlsx', 'Sheet', 'Example Leases');
T2 = readtable('SelfStorageData.xlsx', 'Sheet', 'Typical Move In');
T3 = readtable('SelfStorageData.xlsx', 'Sheet', 'Typical Move out');

[Purnjay Peshawaria]

Thank you so much!!

Answer 2

[Walter Roberson]

Your file is SelfStorageData.xlsx but you try to read SelfStorageData.xls without the final 'x'

[Monalisa Pal]

Opps sorry, I missed the attachment. I just followed the comment. Thanks for pointing it out. I'll edit my answer.

[Purnjay Peshawaria]

Thank you for spotting this.