how to create table and export it to Excel?

4 views (last 30 days)
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

Guillaume
Guillaume on 8 Jun 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]);

More Answers (1)

Peter Perkins
Peter Perkins on 8 Jun 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 Comments

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!