Trouble finding end of a column in Matlab using xlsread
2 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Get Started with MATLAB についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!