values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9};
headers = {'First','Second','Third'};
xlswrite('myExample.xlsx',[headers; values]);

filename = 'myExample.xlsx';
A = xlsread(filename)

filename = 'myExample.xlsx';
sheet = 1;
xlRange = 'B2:C3';
subsetA = xlsread(filename,sheet,xlRange)

filename = 'myExample.xlsx';
columnB = xlsread(filename,'B:B')

[num,txt,raw] = xlsread('myExample.xlsx')

load patients.mat
T = table(LastName,Age,Weight,Smoker);
T(1:5,:)

filename = 'patientdata.xlsx';
writetable(T,filename,'Sheet',1,'Range','D1')

writetable(T,filename,'Sheet',2,'WriteVariableNames',false)

>> [n, files] = get_folder_content( 'c:/A123/', 'myEx', 0, '');

Folder contain files for further processing:
1 file: myEx01.xlsx
2 file: myEx0A.xlsx
3 file: myExCC1.xlsx
Number of listed files: 3

>> allFiles=strvcat(files.name)

allFiles =
myEx01.xlsx
myEx0A.xlsx
myExCC1.xlsx

>> allFiles(1,:)

ans =
myEx01.xlsx


%%%%%%%%%%%%%%%%%
       get_folder_content
%%%%%%%%%%%%%%%%%
% Function return the folder content filtered
% function [ n, datafiles ] = get_folder_content( directory, filepattern, filterout, fpattern)
%
% input:
% - directory
% - filepattern
% - filterout | 1 or 0
% - fpattern | not include files with this pattern
% fpattern is charracter array created by fpattern =
% char('string1', 'string2', ...,'stringn');
% or in case of one string fpattern = 'string';
%
% output:
% - n | number of files
% - datafiles | structure with datafiles
% datafiles(i).name -- sigle file name
% datafiles(i).fullname -- including full path
function [ n, datafiles ] = get_folder_content( directory, filepattern, filterout, fpattern)
%initialisation of the structure
datafiles(1).name = '';
datafiles(1).fullname = '';
if nargin <3,
filterout = 0;
end
tmpdir = dir([directory filepattern '*']);
nn = length(tmpdir);
%filtering not necessary files
cnt = 0;
display('Folder contain files for further processing:')
if filterout==1
[nstr s] = size(fpattern);
filter_flag = 0;
for i=1:nn
for st=1:nstr
S = regexp(tmpdir(i).name,fpattern(st,:));
if(isempty(S))
filter_flag=0;
else
filter_flag=1;
end
end
if(filter_flag==0)
% filter pattern not maching ... so this is correct file
cnt = cnt+1;
datafiles(cnt).name = tmpdir(i).name;
datafiles(cnt).fullname = [directory tmpdir(i).name];
else
%filter pattern matching
%display(['Filtering out: ' tmpdir(i).name ' file'])
end
end
else
for i=1:nn
datafiles(i).name = tmpdir(i).name;
datafiles(i).fullname = [directory tmpdir(i).name];
end
end
n = length(datafiles);
for i=1:n
display([ num2str(i) ' file: ' datafiles(i).name ])
end
display(['Number of listed files: ' num2str(n)]);
return

[files,folder] = uigetfile('*.xls','Select Files','MultiSelect','on');

N=[];
for i=1:numel(files)
myName=fullfile(folder,files{i})
A = xlsread(myName);
N = [N;A];
end

N2 = sortrows(N,[2,3,4]);
xlswrite('c:/myExample.xlsx',N2);