Same dimension for num and txt in xlsread
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Hi,
when I read in an excel file using xlsread, I'd like to have the outputs 'num' and 'txt' to have the same dimensions. It seems to me that by default, they chop off parts on the fringe that either don't contain numerics or text. It's convenient to have the same dimensions for reference purposes. For example, txt(1,2) should give me cell B1, and num(1,2) should also give me cell B1 in the original excel file.
Thanks, Christian
2 comentarios
Kirby Fears
el 11 de Dic. de 2015
Editada: Kirby Fears
el 11 de Dic. de 2015
Have you tried using the raw output of xlsread (output argument 3)? You can extract numerical and text data all from one object if you already know where (cell ranges) to find it.
[num,text,raw] = xlsread('myfile.xlsx');
Respuestas (1)
Walter Roberson
el 12 de Dic. de 2015
one_location = find( cellfun(@(C) isequal(C, 1), raw(:,1)) );
0 comentarios
Ver también
Categorías
Más información sobre Matrix Indexing 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!