How do I make an excel sheet?

Question

Elizabeth 2014-1-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/113509-how-do-i-make-an-excel-sheet

评论： per isakson 2014-1-23

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更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

per isakson 2014-1-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/113509-how-do-i-make-an-excel-sheet#answer_121981

在 MATLAB Online 中打开

Did you try

doc xlswrite

?

2 个评论
显示无隐藏无

Elizabeth 2014-1-23

How do you export data from serial communication to a spread sheet?

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.

请先登录，再进行评论。

Answer 2

David Sanchez 2014-1-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/113509-how-do-i-make-an-excel-sheet#answer_121983

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Elizabeth 2014-1-23

编辑：Elizabeth 2014-1-23

If im using the serial port via arduino and sending the data to matlab how do i get this real time data from matlab to a spreadsheet. This data is random data from a force sensor and not hard coded data.

请先登录，再进行评论。