How to read an excel table and limiting its size (# of rows) to only the data entries

9 次查看（过去 30 天）
Sole
Sole 2020-6-24
评论： Sole 2020-6-29
Hi, I have a table with data filled in from 57 rows and 15 colums. How do I limit the size to 57 by 15 when reading it and be able to use it for other different size tables as well? So ibasing it on the rows with entries in it. When I use the readtable function, I get a 299x15 table in the workspace so most of those rows are blank (NaN).

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

采纳的回答

Kanika Gupta
Kanika Gupta 2020-6-24
编辑：Kanika Gupta 2020-6-24
Yes you can do that, read the documentation around readmatrix herehttps://in.mathworks.com/help/matlab/ref/readmatrix.html
In your case the rectangular range would be A1:BE15
xlRange = 'A1:BE15';
M = readmatrix('Name_Of_EXCEL.xlsx','Sheet','SheetName','Range',xlRange)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by