Export results from several excel files into one excel file

Question

Tatjana Mü 2022-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1700525-export-results-from-several-excel-files-into-one-excel-file

编辑： Tatjana Mü 2022-4-20

Hi,

The plan of my code is this: I want to import several xlsx files. Afterwards I do some calculations. This calculations lead to one line of results for each file. In the end I want to have one file, with one line for every imported file.

I start in my code with a for loop, so that the calculation is made for all excel files (anzahl_files is the number of imported files):

for xy=1:anzahl_files
    fid_in=fopen(char(filename(xy)),'r');

Afterwards I import the data and do some calculations (not so interesting for the question):

tmpImport = importdata(filename{xy},','); 
SP_RL = tmpImport.Tabelle1;
SP_RL = regexprep(SP_RL,'\''',''); 
SP_RL = string(SP_RL);
[NumRows NumCols]=size(SP_RL);
Anzahl_Partikel_RL= NumRows;
for m=1:anzahl_elemente
idx = strfind(SP_RL, element_V_RL(:,m));
idx = find(not(cellfun('isempty', idx)));
Elementanzahl_RL(:,m) = length(idx);
end

Now I have with Elementanzahl_RL my final line. Which I want to export now in one file, row after row into a new file. Therefore I tried to have a for loop like this:

for j=1:anzahl_files
Partikel_RL(j+1,:)=Elementanzahl_RL(j,:);
end
end

Anzahl_files is my number of files, which I imported. The second end in this part, is for the first for loop. But sadly its not working and gives me following error:

Index in position 1 exceeds array bounds (must not exceed 1).
Error in TOF_Skript_SingleParticlesgesamt (line 81)
Partikel_RL(j,:)=Elementanzahl_RL(j,:);

I dont find my mistake, does somebody has an idea?