how to automatically import multiple excel files, each contains 3D coordinates, into matlab?

I've 115 excel files each contains 3 columns named X, Y and Z.

Is it possible to import these data automatically, in a way that each X, Y and Z will be named X"filename", Y"filename" and Z"filename"??

Thank you very much for your help

Answer 1

[Akiva Gordon]

The naming model that you suggest is not really the best way to name your variables. Consider the following:

Get the list of files that end with ".xls",

files = dir('*.xls')

For each element in "files", read the Excel data of that file and define structure of x, y, & z

for i = 1:numel(files)

      data = xlsread(files(i).name);   

      x.(files(i).name) = data(:,1);
      y.(files(i).name) = data(:,2);
      z.(files(i).name) = data(:,3);

end

Sorry I didn't get a chance to test this, so I hope this works for what you are trying to do. Also, if the files are sequentially numbered and the number of rows are the same in each file, you may want to consider storing the data in standard arrays (i.e. x(:,i)), rather than in structures.

[AAA]

Dear Akiva, Thank you very much for your answer. I've tried to use the command lines. it gave me the following: "files =

0x1 struct array with fields: name date bytes isdir datenum"

May be I need to give more description: I'm using matlab on a mac. the manual method that gave me the wanted results was as follows: 1. import data, 2. create vector from each column using column names. 3. renaming the X, Y, & Z, into X_filename, Y_filename, and Z_filename.

I'm looking for a method to do that to all the files automatically.

Thank you very much for your help.

Have a great day,