Effacer les filtres
Effacer les filtres

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

1 vue (au cours des 30 derniers jours)
Usman
Usman le 22 Déc 2015
Commenté : Usman le 23 Déc 2015
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);

Réponses (1)

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

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by