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

9 visualizaciones (últimos 30 días)
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).
  2 comentarios
KSSV
KSSV el 24 de Jun. de 2020
You can specify the range of sheet to be read..read the documentation.
Fangjun Jiang
Fangjun Jiang el 24 de Jun. de 2020
Or read all in and then process. I always find that is easier.

Iniciar sesión para comentar.

Respuesta aceptada

Kanika Gupta
Kanika Gupta el 24 de Jun. de 2020
Editada: Kanika Gupta el 24 de Jun. de 2020
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)

Más respuestas (0)

Categorías

Más información sobre Logical en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by