Trouble finding end of a column in Matlab using xlsread
1 view (last 30 days)
Show older comments
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 Comments
Answers (1)
See Also
Categories
Find more on Get Started with MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!