how to find certain values in cells ?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
see attached.
I am using xlsread to load data from an xls file into matlab as a cell. I would like to return all the cell values in the first column starting from row 15 until the first NaN into a variable called "List"(of type cell or integer preferably).
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/161676/image.png)
0 commentaires
Réponse acceptée
Ghost
le 18 Avr 2016
Define your sheet and xlrange something similar to this
for f = 1:end;
A(:,f) = ALL(:,f);
sheet = 1;
xlRange = 'A2';
xlswrite(Exel_filename,A,sheet,xlRange)
end
3 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Environment and Settings dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!