creating a function that reads into the directory

Hi, i want to create a function that uses the file prefix, directory name and file type as inputs to pick up files that i want to process from my directory. Below is my code but it is not working, it says Dot indexing is not supported for variables of this type. As an example, i might be looking for all excel spreadsheets that have the prefix DynamicData in my directory pwd, but i want my code to give the output as TableFiles. Please help !!!

FilePrefix ='DynamicData';
        DirectoryName = pwd;
        filetype='.xlsx'
        FileList = strcat(['DirectoryName','FilePrefix','*','filetype']);
    TableFiles = {};    
for LenFlLst = 1:numel(FileList)
   TableFiles = {FileList.name};
end

Answer 1

[Ameer Hamza]

you also need to use dir() to get actual file names. Try this code

% FilePrefix ='DynamicData';
FilePrefix ='test';
DirectoryName = pwd;
filetype='.xlsx';
FileList = fullfile(DirectoryName,[FilePrefix,'*',filetype]); % fullfile is better to construct file paths
FileList = dir(FileList);
TableFiles = cell2table({FileList.name}.', 'VariableNames', {'Filenames'});

[WILLBES BANDA]

Thank you honourable, it works perfectly fine

[Ameer Hamza]

I am glad to be of help!