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

Question

Purnjay Peshawaria 2020-6-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/552052-how-to-import-data-from-multiple-worksheets-contained-in-1-workbook

编辑： Purnjay Peshawaria 2020-6-22

采纳的回答： Monalisa Pal

SelfStorageData.xlsx

在 MATLAB Online 中打开

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Monalisa Pal 2020-6-22

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/552052-how-to-import-data-from-multiple-worksheets-contained-in-1-workbook#answer_455170

编辑：Monalisa Pal 2020-6-22

在 MATLAB Online 中打开

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');