xlsread doesn't read a column that contains string in the cells with unknown number of rows
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
farzad
el 20 de Jun. de 2019
Respondida: Dimitar Georgiev
el 20 de Jun. de 2019
Hi all
I am trying to read from an xlsx Excel file some rows in clumn 1 that are strings.
xlsread alone does not function
how to read all and put into a list ?
9 comentarios
Bob Thompson
el 20 de Jun. de 2019
A conversion to what? What are you looking to do with it? all(1) is a cell class element, but all{1} is a string class, which can be used as an input for other commands, such as a file reading function.
Respuesta aceptada
Dimitar Georgiev
el 20 de Jun. de 2019
You can use readcell, for example,
example = readcell('example.xlsx','Range','A2:P5');
Now you can extract strings from the cell array.
I would recommend you to read:
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Type Conversion en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!