for loop and xlswrite

Hi,i want to use xlswrite to write my data using for loop but the issue I am facing that if i have for loop with decimal interval then how can i write it to excel (discrete cells),e.g

for k=1:0.5:5
    x=rand;
 my_cell = sprintf( 'A%s',num2str(k) );
 xlswrite('my_xls.xls',x,1,my_cell);
 end

by using this i got error,please help me in writing such stuff. Thanks* |

Answer 1

[Sara]

K is not an integer so you can't use it to select the excel cell. Do this:

j = 0;
for k=1:0.5:5
    j = j + 1;
    x=rand;
    my_cell = sprintf( 'A%s',num2str(j) );
    xlswrite('my_xls.xls',x,1,my_cell);
 end

[Muhammad Usman]

Thanks