how to automatically import multiple excel files, each contains 3D coordinates, into matlab?
11 views (last 30 days)
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
Akiva Gordon on 8 Nov 2012
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);
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.