store matlab table to excel

9 views (last 30 days)
irene stella
irene stella on 17 Mar 2019
Commented: irene stella on 17 Mar 2019
filename = 'test.xlsx';
A = xlsread(filename,3,'A1476:D8676');
time = A(:,1);
x = A(:,2);
y = A(:,3);
z = A(:,4);
.......
........
T1=table(time,x,y,z);
T2=table(a,b,c);
T3=table(d,e,f);
fileName2='C:\Desktop\CODE.xlsx';
writetable(T1,fileName2,1);
writetable(T2,fileName2,2);
writetable(T3,fileName2,3);
THE RESULT IS NOT WRITTEN IN EXCEL BUT TO MATLABS WORSPACE
WHA TO DO???
THERE ARE 200 DIFFRENT FOLDERS....
  4 Comments
Walter Roberson
Walter Roberson on 17 Mar 2019
Do you get any error message for the writetable() calls ?
You should probably be using 'sheet' keyword, like
writetable(T1, fileName2, 'sheet', 1)
irene stella
irene stella on 17 Mar 2019
thank you very very much!!!!

Sign in to comment.

Answers (0)

Community Treasure Hunt

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

Start Hunting!