export values to specific cell in excell

hello, i want to creat a column in excell from values i get from matlab. example:

for i:1:10

x=i;

xlswrite(data,x);

end

to get in excell- [1 2 3 4 5 6 7 8 9 10]

but it always write only the last value- [10]

Answer 1

[Sulaymon Eshkabilov]

Do not use a loop operation that is not efficient and xlswrite(). Use the following syntax:

writematrix((1:10).', 'MY_Data.xlsx');

[lital levy]

thanks but I get my values from a loop, it is location cordinates that changes in every loop, can i save each value and send it to excell?

Answer 2

[Sulaymon Eshkabilov]

Then you may need to use this syntax:

Data = [];
 for ii = 1:13
    N = ii;
    Data = [Data; {N}];  % Accumulate all data in a single cell array
 end
 writecell(Data, 'MY_data1.xls')
 winopen('MY_data1.xls')