store matlab table to excel

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 件のコメント

Walter Roberson
Walter Roberson 2019 年 3 月 17 日
Could you explain what you mean about it being written to MATLAB's workspace?
Does C:\Desktop exist? Normally Desktop is further down than that in the folders, C:\Users\(username)\Desktop
irene stella
irene stella 2019 年 3 月 17 日
my code runs...
and gives me outpout for table T1,T2,T3...
and I can read them in matlabs workspace...
but I want them t be stored direcly in excel file which is on the desktop
I have changed the directory name to : C:\Users\Sakoulis\Desktop\RESULTS\CODE.xlsx
Walter Roberson
Walter Roberson 2019 年 3 月 17 日
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 2019 年 3 月 17 日
thank you very very much!!!!

サインインしてコメントする。

回答 (0 件)

タグ

質問済み:

2019 年 3 月 17 日

コメント済み:

2019 年 3 月 17 日

Community Treasure Hunt

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

Start Hunting!

Translated by