how to create table and export it to Excel?

I have few vectors at the same length that contains numbers. I want to export them to the Excel or Word. how i do it?

 Réponse acceptée

Guillaume
Guillaume le 8 Juin 2015
v1 = [1 2 3 4 5]; v2 = [6 7 8 9 10]; v3 = [11 12 13 14 15];
xlswrite('somefile.xlsx', [v1;v2;v3]);

Plus de réponses (1)

Peter Perkins
Peter Perkins le 8 Juin 2015
Alternatively,
>> v1 = [1 2 3 4 5]'; v2 = [6 7 8 9 10]'; v3 = [11 12 13 14 15]';
>> t = table(v1,v2,v3)
t =
v1 v2 v3
__ __ __
1 6 11
2 7 12
3 8 13
4 9 14
5 10 15
>> writetable(t,'somefile.xlsx');

6 commentaires

eran golden
eran golden le 10 Juin 2015
is it possicle that "table" function doesn't exist in the version of 2011?
Guillaume
Guillaume le 10 Juin 2015
Yes, it came with 2013b or 2014a
Ambati Sathvik
Ambati Sathvik le 2 Juil 2020
You saved my day
Thanks
Thank you....very very much
Lukas Sokol
Lukas Sokol le 18 Mar 2021
much love

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by