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 Kommentare

Walter Roberson
Walter Roberson am 17 Mär. 2019
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 am 17 Mär. 2019
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
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 am 17 Mär. 2019
thank you very very much!!!!

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Gefragt:

am 17 Mär. 2019

Kommentiert:

am 17 Mär. 2019

Community Treasure Hunt

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

Start Hunting!

Translated by