How to compile two different array type into one variable

rootdir = 'C:\Users\acer\Desktop\abc';

filelist = dir(fullfile(rootdir,'**\*.xlsx'));

X = []; Y = [];

for ii = 1:length(filelist)

filelist(ii).data = importdata(fullfile(filelist(ii).folder,filelist(ii).name));

filelist(ii).data = (filelist(ii).data(:,:));

end

% combine all the data, one after the other, vertically:

all_data = vertcat(filelist.data); %this is where the error lies, since the data file were struct and cell

% How to convert all struct to cell assuming I have multiple struct file.

[Stephen23]

"How to compile two different array type into one variable"

What makes you think that the data can be meaningfully combined? It might be simple to combine, or it might be very complex (consisting of exception handling and special cases). We don't know.

Note that you should replace awful IMPORTDATA with a much better file-data importing function, e.g. READTABLE, READCELL, READMATRIX, or the like. Avoid IMPORTDATA.

Answer 1

[Suman]

Hi Morin,

You need to first convert the struct to cell array to be able to concatenate them. You can use the 'struct2cell' function to achieve that. https://in.mathworks.com/help/matlab/ref/struct2cell.html

Also note that, in order to concatenate cell arrays, they must be of equal dimensions. In your case, the cell arrays in the data column are of unequal dimensions, so you must either pad the cell array with zeros or NaN to make the dimensions equal before you can concatenate them. Please refer to these MATLAB Answers to see the examples,

• https://in.mathworks.com/matlabcentral/answers/2128126-extracting-data-from-struct-as-array?s_tid=answers_rc1-1_p1_MLT
• https://in.mathworks.com/matlabcentral/answers/2128161-extracting-data-from-struct-as-matrix/?s_tid=ans_lp_feed_leaf