How to save the data from serial port continuesly through csv or xls?
5 views (last 30 days)
Show older comments
Hello all!
I wonder to know how can i save the data from serial port continuesly through .csv or .xls.
I have do some works before.I have used the xlswrite such as
xlswrite(name,data, 'Sheet1',str)
to save the data through change the str(change the sheet location to be written),e.g. First is A1:F10,Second is A11:F20 to achieve continuesly save.
It is useful,but i think this method looks some stupid ...
I wonder is there exist some other methods to solve this problem.
I would greatly appreciate if you kindly give me some some advice.
0 Comments
Accepted Answer
Walter Roberson
on 31 Jul 2017
fid = fopen('YourOutput.csv', 'wt');
while true
YourNumericData = ...
ncol = size(YourNumericData, 2);
fmt = [repmat('%g,', 1, ncol-1), '%g\n'];
fprintf(fid, fmt, YourNumericData .' ); %transpose is important
end
fclose(fid);
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!