Clear Filters
Clear Filters

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

1 view (last 30 days)
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)

Walter Roberson
Walter Roberson on 22 Dec 2015
[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
Usman
Usman on 23 Dec 2015
sir you ammendment code still gives the value of single frame. I want to store all values in excel file

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!