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

3 ビュー (過去 30 日間)
Usman
Usman 2015 年 12 月 22 日
コメント済み: 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);

回答 (1 件)

Walter Roberson
Walter Roberson 2015 年 12 月 22 日
[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 件のコメント
Usman
Usman 2015 年 12 月 23 日
sir you ammendment code still gives the value of single frame. I want to store all values in excel file

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by