Same dimension for num and txt in xlsread
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Kirby Fears
il 11 Dic 2015
Modificato: Kirby Fears
il 11 Dic 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');
Risposte (1)
Walter Roberson
il 12 Dic 2015
one_location = find( cellfun(@(C) isequal(C, 1), raw(:,1)) );
0 Commenti
Vedere anche
Categorie
Scopri di più su Matrix Indexing in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!