export values to specific cell in excell

1 view (last 30 days)
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]

Answers (2)

Sulaymon Eshkabilov
Sulaymon Eshkabilov on 17 Aug 2022
Do not use a loop operation that is not efficient and xlswrite(). Use the following syntax:
writematrix((1:10).', 'MY_Data.xlsx');
  1 Comment
lital levy
lital levy on 17 Aug 2022
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?

Sign in to comment.


Sulaymon Eshkabilov
Sulaymon Eshkabilov on 17 Aug 2022
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')

Tags

Products


Release

R2021a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!