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?

 Accepted Answer

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

More Answers (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 Comments

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

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!