How to create multiple tables from a single spreadsheet

2021 11 17
1 个回答
回答已采纳
更新时间：2021 11 17
5 次查看（30 天）

0 个投票

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?

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

 采纳的回答

Dave B
Dave B 2021-11-17

0 个投票

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
Federico Migliosi 2021-11-17
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
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.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

版本

R2021b

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by