How can I export variales from double and structure with different rows into excel?

2 次查看(过去 30 天)
Hello everyone,
I have variables in 8x1 double, in 40x1 double under 1x1 struct, and 1x1 double. Since I have the same varibles for different trials saved in different MATLAB files, I was trying to save all the variables from each trial in a table first and export to a excel for all trials. Then, copy and paste variables from each excel for each trial, and put them all together in a new excel. But when I run the code for making a table (as shown below), it gets into an error:
Error using table (line 233)
All table variables must have the same number of rows.
KineVar=table(AbdAngleMax,AbdAngleMin,AbdAngleChange,speed,FinSwingDist.dist,TailSwingDist.dist)
EMGvariable.Properties.VariableNames{1} = 'AbdAngleMax';
EMGvariable.Properties.VariableNames{2} = 'AbdAngleMin';
EMGvariable.Properties.VariableNames{3} = 'AbdAngleChange';
EMGvariable.Properties.VariableNames{4} = 'speed';
EMGvariable.Properties.VariableNames{5} = 'FinSwingDist.dist';
EMGvariable.Properties.VariableNames{5} = 'TailSwingDist.dist';
fileName='KINEvariableResults.xlsx'
writetable(KINEvariable,fileName)
winopen(fileName)
Is there anything I could do to fix the issue? Or should I not use the table function?
Thank you very much for your help!
  3 个评论
lisa Liang
lisa Liang 2020-10-1
Thank you for your answer! Yes, you are right.
"AbdAngleMax","AbdAngleMin","AbdAngleChange" are in 8x1 double, and "FinSwingDist.dist","TailSwingDist.dist" are in in 40x1 double of a 1x1 struct,
"speed" is in 1x1 double.
Do you mean that I should turn the 1x1 and 8x1 doubles into 40x1 double and fill it up with NaNs?

请先登录,再进行评论。

采纳的回答

Mario Malic
Mario Malic 2020-10-1
These have to have same number of rows, which they don't, according to your first sentence.
AbdAngleMax,AbdAngleMin,AbdAngleChange,speed,FinSwingDist.dist,TailSwingDist.dist
Fill up your variables with NaN's to match the maximum number of rows that a variable has.
  3 个评论
Mario Malic
Mario Malic 2020-10-1
编辑:Mario Malic 2020-10-1
If you know that maximum number of rows is 40, initialize it with NaN, if that would not make a problem in your calculations
AbdAngleMax = NaN(40,1)
Otherwise,
L = length(AbdAngleMax)
AbdAngleMax(L+1:40,1) = nan;
% repeat for the rest of variables/structs

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by