How do I make an excel sheet?
1 view (last 30 days)
Show older comments
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 Comments
Answers (2)
per isakson
on 23 Jan 2014
Did you try
doc xlswrite
?
2 Comments
per isakson
on 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
on 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)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!