How do I make an excel sheet?
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(2 个)
per isakson
2014-1-23
Did you try
doc xlswrite
?
2 个评论
per isakson
2014-1-23
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
2014-1-23
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)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!