Trouble finding end of a column in Matlab using xlsread
조회 수: 1 (최근 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에서 Logical에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!