- List the file names (and full paths, if possible) to all excel sheets in a cell array.
- Create a loop that will loop through each excel sheet.
- Use xlsread() to read in each sheet within the loop and store the vector values.
- After the loop, put the values together into 1 long vector.
- Use xlswrite() to write the data into a new sheet.
Here's a template. After you read through the options in xlsread() and xlswrite() (see the links I provided), you can adapt the template to your needs.
% 1) list file names
excelFiles = {'C:\Users\vasillevski\Documents\MATLAB\sheet1.xlsx',
'C:\Users\vasillevski\Documents\MATLAB\sheet2.xlsx',
'C:\Users\vasillevski\Documents\MATLAB\sheet3.xlsx',
'C:\Users\vasillevski\Documents\MATLAB\sheet4.xlsx'};
% 2) loop through files
vectorData = cell(length(excelFiles, 1));
for i = 1:length(excelFiles)
% 3) read data
vectorData{i} = xlsread(excelFiles{i}); %adapt as needed, see documentation
end
% 4) combine values
vec = cell2mat(vectorData);
% 5) Write data to new excel file
newFileName = 'C:\Users\vasillevski\Documents\MATLAB\ALL_DATA.xlsx',
xlswrite(newFileName,vec) %adapt as needed, see documentation
Not tested.
