There are a few different ways to get this task done. One of them is this one if your data files have the same number of numerical data sets (there is just one row of data in each file you stated):
FILE = fullfile('C:\Users\...', '*.xlsx'); % Directory where the files are residing.
LIST = dir(FILE);
N = length(LIST); % N number of files
Ncols = ??? % Ncols how many columns of data in
D = zeros(N, Ncols);
for ii = 1 : N
FFName = fullfile(LIST(ii).folder, LIST(ii).name);
DATA = readmatrix(FFName);
D(ii, :) = DATA; % NOW D contains all data from 100 files
end
