How to move files from current folder to workspace automatically?

3 次查看（过去 30 天）

显示更早的评论

Ibrahim AlZoubi 2020-5-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/526041-how-to-move-files-from-current-folder-to-workspace-automatically

编辑： Stephen23 2020-5-18

采纳的回答： Stanislao Pinzón

How to make this automatically when I select path of the file (Browse for folder) move all tables to Work space?

EX:

I wanna make these files moved automatically to workspace.

采纳的回答

Stanislao Pinzón 2020-5-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/526041-how-to-move-files-from-current-folder-to-workspace-automatically#answer_432897

在 MATLAB Online 中打开

You can do this using structures and the dir function. The following code could help.

filesDIR = dir;
c = 0;
for i=1:length(filesDIR)
    if contains(string(filesDIR(i).name),{'.xlsx'})
        c = c+1;
        ExcelFiles.(strcat('F',num2str(c))) = xlsread(filesDIR(i).name);
    end
end

13 个评论
显示 11更早的评论隐藏 11更早的评论

Stanislao Pinzón 2020-5-17

在 MATLAB Online 中打开

Array = ExcelFiles.F1;

Stephen23 2020-5-17

编辑：Stephen23 2020-5-18

在 MATLAB Online 中打开

Rather than getting dir to return te entire directory contents and then filtering the names afterwards it is simpler and more efficient to supply a suitable match string to dir:

S = dir('*.xlsx');
for k = 1:numel(S)
    M = xlsread(S(k).name);
    ... do something with M
end

Using a cell array would be simpler and more efficient than dynamically creating structure fieldnames:

S = dir('*.xlsx');
N = numel(S);
C = cell(1,N);
for k = 1:N
    C{k} = xlsread(S(k).name);
end

and is also exactly what the MATLAB documentation recommends:

https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html

请先登录，再进行评论。

更多回答（1 个）

Walter Roberson 2020-5-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/526041-how-to-move-files-from-current-folder-to-workspace-automatically#answer_432896

You can use uigetfile() to get the folder name. Then you can use dir() to find the xlsx files in the folder. Then you can loop using readtable() and assigning the result into a cell array, or perhaps into a struct... you could even make a table of tables, I suppose.

However, we advise that you do not create new variable names corresponding to each file. http://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval