How to extract data from multiple excel files

I am attempting to create a 3D map of 101 sets of data, each set is in a seperate excel spreadsheet, all sets are within 1 folder.

My MatLAB knowledge is minimal, but this is my attempt at the code:

nFiles=101
filenamePrefix='F1--Trace-no loop-0000--0000';
filenameExtension='.csv';
for i = 1:nFiles
  filename = [filenamePrefix, int2str(i), filenameExtension];
  tmpData =  readmatrix(filename, 'NumHeaderLines',1)
  x{i}=tmpData(:,1);
  y{i}=tmpData(:,2); 
end
mesh(x{i},y{i},i}

Please give any advice or alternative codes that could work

[dpb]

"create a 3D map of 101 sets of data, "

Can you explain precisely what the end result wanted is and what the data are/how they relate to the desired result?

As to alternatives, I'd probably start with something like--

d=dir('F1--Trace-no loop-0000--0000*.csv');  % return all files
for i=numel(d)
  tmpData =  readmatrix(d(i).name, 'NumHeaderLines',1);
  ...

It's what's next that depends on what it is wanting to do with the data and what it is that the data are.

Answer 1

[Samatha Aleti]

You may find the relevant answer here