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?

 Akzeptierte Antwort

Guillaume
Guillaume am 8 Jun. 2015

0 Stimmen

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

Weitere Antworten (1)

Peter Perkins
Peter Perkins am 8 Jun. 2015

3 Stimmen

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 Kommentare

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

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by