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?

 Risposta accettata

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

Più risposte (1)

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 Commenti

is it possicle that "table" function doesn't exist in the version of 2011?
Yes, it came with 2013b or 2014a
You saved my day
Thank you....very very much
much love

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by