how to save series of values under one excel file MATLAB?

I want to store pitch, yaw and roll for each frame in excel file. eg: if 144 frames then excel stores 144 values of pitch,yaw and roll in one excel file. The code which i tried stores only first frame value.
[pitch,yaw,roll] = ComputePose(PDM_49,test_shape(:));
filename='data.xlsx';
header = {'Pitch', 'yaw ','roll'};
xlswrite(filename,header);
[~,~,input] = xlsread(filename);
new_data = {pitch,yaw,roll};
output = cat(1,input,new_data); % Concatinate your new data to the bottom of input
xlswrite('data',new_data);

Answers (1)

[pitch,yaw,roll] = ComputePose(PDM_49,test_shape(:));
header = {'Pitch', 'yaw ','roll'};
new_data = num2cell([pitch(:), yaw(:), roll(:)]);
output = [header; new_data];
xlswrite('data',output);

1 Comment

sir you ammendment code still gives the value of single frame. I want to store all values in excel file

Sign in to comment.

Asked:

on 22 Dec 2015

Commented:

on 23 Dec 2015

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!