MATLAB: How to import several files of excel into a table in Matlab

importing excel data

Dear community

When I use the function "import data", only allows to import one excel file.

The issue is, I have several excel files in one folder and I need to import all that excel files.

Anyone knows a loop that allow to import all that excel files?

Thanks in advance

Best Answer

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Related Solutions

MATLAB: How to import all sheets of excel file with “UIgetfile” option

Use uigetfile to select the file. Then use that name in your second code to import all the sheets. Maybe something like this (untested)

[xlsfile,paht2xls] = uigetfile(filter,'Import-Daten');
[~,sheet_name] = xlsfinfo(fullfile(paht2xls,xlsfile));
for k = 1:numel(sheet_name)
    data{k} = xlsread(fullfile(paht2xls,xlsfile),sheet_name{k});
end

MATLAB: Unable to perform assignment because the indices on the left side are not compatible with the size of the right side.

v= Voc(j:k,1);

That is creating a non-scalar cell array

a=cellfun(@mean,v);

That is going through each cell member and taking the mean of each. The fact that you did not get an error on this line tells us that each cell member was a scalar or a vector, not empty and not 2 D or more. The end result will be a vector of length k-j+1 = 9.

    Voc_p(i,1)=a;

You are trying to store that vector of length 9 into a single location, Voc_p(i,1)

Best Answer

Related Solutions

MATLAB: How to import all sheets of excel file with “UIgetfile” option

MATLAB: Unable to perform assignment because the indices on the left side are not compatible with the size of the right side.

Related Question