MATLAB: How would automatically import excelfiles into MATLAB

import

Hi, guys. I want to automatically import excelfiles into MATLAB. I use this code.

--------------------------------------------
source_dir = 'C:/Users/Cju/Documents/MATLAB/a' ;
source_files = dir(fullfile(source_dir, '*.xlsx'));
for i = 1:length(source_files) ;
   data(i) = xlsread(fullfile(source_dir, source_files(i).name));
end
--------------------------------------------

But just import final file. What is wrong?

Best Answer

Chances are that won't work unless your workbooks have only a single scalar value in them. You would need data to be a cell array

data{i} = xlsread(.......

Please read the FAQ: http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F

Related Solutions

MATLAB: Load plenty of xlsx files

See: FAQ: process-a-sequence-of-files

Either create the file names automatically:

Folder = cd;   % Set accordingly

for k = 1:10
  FileName = sprintf('Data_1_File_%d.xlsx', k);
  [~, ~, raw] = xlsread(fullfile(Folder, FileName), 'Tabelle1');  
  ...
end

Or use all files inside the folder:

Folder   = cd;   % Set accordingly
FileList = dir(fullfile(Folder, '*.xlsx'));
for k = 1:numel(FileList)
   FileName = FileList(k).name;
   [~, ~, raw] = xlsread(fullfile(Folder, FileName), 'Tabelle1');
   ...
end

It works with a list obtained by uigetfile also:

[Filename, Path] = uigetfile({'*.xlsx','DEWE Files(*.xlsx)'}, ...
                             'MultiSelect', 'on','C:\...');
for k = 1:numel(Filename)
  File = fullfile(Path, Filename{k});
  [~, ~, raw] = xlsread(File, 'Tabelle1');
  ...
end

By the way: Reading all FAQ is strongly recommended: http://matlab.wikia.com/wiki/FAQ .

MATLAB: How to import numerous excel files into MATLAB

You won't be able to load them all at once but you could easily use a for-loop to process them one at a time. Something like this:

source_dir = 'path/to/source/'
dest_dir = '/path/to/dest'
source_files = dir(fullfile(source_dir, '*.xls'));
for i = 1:length(source_files)
  data = xlsread(fullfile(source_dir, source_files(i).name)));
  #do something with data
  xlswrite(fullfile(dest_dir, source_files(i).name)));
end

Best Answer

Related Solutions

MATLAB: Load plenty of xlsx files

MATLAB: How to import numerous excel files into MATLAB

Related Question