Borrar filtros
Borrar filtros

export values to specific cell in excell

1 visualización (últimos 30 días)
lital levy
lital levy el 17 de Ag. de 2022
Respondida: Sulaymon Eshkabilov el 17 de Ag. de 2022
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]

Respuestas (2)

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

Iniciar sesión para comentar.


Sulaymon Eshkabilov
Sulaymon Eshkabilov el 17 de Ag. de 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')

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by