How do I make an excel sheet?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello all,
I am doing a project in order to import force values from an arduino to matlab.I am a beginner with the whole matlab program. I have my coding set up and now i want to incorporate a function or a button to have those values transfer from the matlab program to an excel sheet. What is the easiest way of doing this. Mind you these values are being transferred in real time.
0 commentaires
Réponses (2)
per isakson
le 23 Jan 2014
Did you try
doc xlswrite
?
2 commentaires
per isakson
le 23 Jan 2014
Call xlswrite repeatedly, but that is probably not practical because of the poor performance of MsExcel.
Better, I think, is to save to simple file and export to Excel in a second step.
David Sanchez
le 23 Jan 2014
xlswrite(filename,A,xlRange) writes to the rectangular region specified by xlRange in the first worksheet of the file.
filename = 'testdata.xlsx';
A = [12.7, 5.02, -98, 63.9, 0, -.2, 56];
xlswrite(filename,A)
if you want to write in a specific sheet and range:
filename = 'testdata.xlsx';
A = {'Time','Temperature'; 12,98; 13,99; 14,97};
sheet = 2;
xlRange = 'E1';
xlswrite(filename,A,sheet,xlRange)
1 commentaire
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!