How to log(append) the data to excel sheet continously when using 'while' loop?

Question

Prajwal Ramakrishna 2018-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393189-how-to-log-append-the-data-to-excel-sheet-continously-when-using-while-loop

编辑： Prajwal Ramakrishna 2018-4-6

Hello! I am using MATLAB to read a real-time serial data. I am using a 'while' loop to iterate the loop continuously. Within the while loop I have a resultant matrix which stores the variables i require. Then I use 'xlswrite' command to store these values. But the problem is, for every iteration this file 'sampletest.xlsx' gets rewritten. I want the new values of every iteration to be stored in the same file i.e. they have to get appended below the previous set of values. How can I achieve this? Hoping to find some help.

while <condition> 
. 
.
.
filename = 'sampletest.xlsx'; 
D = [(vfl) (vfr) (vrl) (vrr) (temp) (tps) (delta) (time) (vv) (Ax) (s_rr) (s_rl)] %concatenated matrix 
sheet = 1;
log_data = xlswrite(filename,D,sheet);
.
. 
end