Trouble finding end of a column in Matlab using xlsread
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
The data i am reading in is in the form of an xls format so I use xlsread in matlab to read it in. The data is a mixture of numbers and letters. Due to this fact I use the raw format of xls read. The purpose of my program is to rearrange the data into a specified format.
My problem is that I am unable to find the correct end to a column when using a while loop.
One of my attempts is below:
while((alldata(i,4)~= 0)&&(i < (x-1)))
Temparray(i-6,3) = alldata(i,4);
xlswrite('output.xls',a,'Sheet1',sprintf('B%d',i-6));
xlswrite('output.xls',a,'Sheet1',sprintf('G%d',i-6));`enter code here`
i = i+1;
end
I wish it to stop when it reaches a blank cell or empty cell.
Any help would me much appreciated.
Thanks!
Joe
0 commentaires
Réponses (1)
Voir également
Catégories
En savoir plus sur Get Started with MATLAB dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!