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

Question

Usman 2015-12-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261372-how-to-save-series-of-values-under-one-excel-file-matlab

评论： Usman 2015-12-23

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);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2015-12-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/261372-how-to-save-series-of-values-under-one-excel-file-matlab#answer_204068

在 MATLAB Online 中打开

        [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);