Use of a loop to read and concat multiple cell table

Hello,

I have a 24x1 cell named 'results'. Each cell consists of 36977x16 double table. I want to read a particular column, say column number 12, in each of these 24 cells and return the maximum value in that column matrix. Here I have created a 24x1 cell named 'results' by reading 24 .csv files. I was trying to use a 'for' loop but did see any success.

files = dir('*.csv');

num_files = length(files);

results = cell(length(files), 1);

for i = 1:num_files

results{i} = xlsread(files(i).name);

end

Answer 1

[Anirudh Peralai Ravisundar]

My questions relates to extracting data from the 12th column of results{i}. Essentially, results{i} is a 24x1 cell where a table of 36977x16 double constitutes each cells.

[VBBV]

results{i} = xlsread(files(i).name);
K{i} = results{i}(:,12);

Add this line in loop. K is the array with data extracted from 12th col of each of cell arrays.