read multiple excel files with beginning part of file name being similar

2 次查看（过去 30 天）
Ahisa
Ahisa 2021-7-6
编辑： Ahisa 2021-7-7
I have 4 excel files that all start with THA and there are 4 types(THA1, THA2, THA3 & THA4) the full file name for all 4 are like this: THA1_343fdf and I want to extract all four file names by filtering it with THA if possible. I can extract the data easily but struggling with extracting all 4 file names.
  13 个评论
显示 11更早的评论
dpb
dpb 2021-7-7
tData=readtable(fullfile(d(i).folder,"d(i)name"))
It's doing exactly what you told it to do -- it's looking for the literal string "d(i)name" as the file name, not the next file in the dir() struct d() array that you returned.
Look at the documentation for dir and the examples there and look at what the call returns in the variable d struct at the command line to understand what you're doing here.
The code is, as I wrote initially,
tData=readtable(fullfile(d(i).folder,d(i)name));
Remove the quotes; they don't belong...
Ahisa
Ahisa 2021-7-7
编辑：Ahisa 2021-7-7
never mind, this is how it should look, correct?
d=dir(fullfile('C:\Users\R101951\Desktop\RB\New folder','THA*.*'));
for i=1:numel(d)
tData=readtable(fullfile(d(i).folder,d(i).name));
end

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Jonas
Jonas 2021-7-7
编辑：Jonas 2021-7-7
more something like that?
for type=1:4
basepath='C:\Users\R101951\Desktop\RB\New folder\';
currFile=dir([basepath 'THA' num2str(type) '*.xls']).name;
data=readtable(currFile,.....);
end
the ' * ' is a wildcard for the '_343fdf' part which I assumed is not the same for every file you are interested in
  1 个评论
Ahisa
Ahisa 2021-7-7
↑
Error: Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for
mismatched delimiters.
thanks for that, i tried yours b
ut got this error message

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by