How to create multiple tables from a single spreadsheet

Question

Federico Migliosi 2021-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1589004-how-to-create-multiple-tables-from-a-single-spreadsheet

评论： Dave B 2021-11-17

采纳的回答： Dave B

I have a single .xlsx spreadsheet with multple tables on the same page, but one below the other.

The picture below shows an example.

From this spreadsheet I want to create two different tables at the same time. I have tried using the import tool or the readtable() function but I did not succeed.

Can someone help me?

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

请先登录，再进行评论。

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

Answer 1

Dave B 2021-11-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1589004-how-to-create-multiple-tables-from-a-single-spreadsheet#answer_833864

You can specify a range when calling readtable:

For example:

T = readtable('patients.xls',...
    'Range','C2:E6',...
    'ReadVariableNames',false)

If you attach your excel file we can help with it, but it's really as easy as specifying the excel column and row for the upper left and lower right corners.

2 个评论
显示无隐藏无

Federico Migliosi 2021-11-17

isar 400km.xlsx

Thank you for the quick response.

Your code will just create one table from the specified upper left and lower right corners.

I was looking for a way to create multiple tables at once, each with a couple of unique corners. For now I think I will just create the tables manually, each time specifing the correct corners.

I have attached the excel file if it helps.

Dave B 2021-11-17

Sadly, I don't think there's any way to create multiple tables with one call to readtable.

If you really wanted to you could write a little function that looped over a set of ranges to return multiple tables (just to make it easier to read), but you'd be faced with choosing whether the output should be a cell array of tables (?) or if you'd vary the number of output arguments based on the number of ranges. Both would be a little awkward IMO.

请先登录，再进行评论。