Creating automatically a folder name and cd the folder based on excel file name

Question

Wesso 2021-12-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1613775-creating-automatically-a-folder-name-and-cd-the-folder-based-on-excel-file-name

回答： Image Analyst 2021-12-18

Hi, I have excel names based on countries. for example I have Iraq.xlsx file save under C:\Documents\MATLAB so, I write :

T = readtable('Iraq.xlsx') ;

is it possible when i read the file of iraq to assign automatically a folder name called iraq and cd it in C:\Documents\MATLAB\Iraq. in other words any further computation will be saved in the folder iraq

so if i write for example:

uniquecities=unique(T.city);

save uniquecities

it will be save automatically in the folder iraq

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Stephen23 2021-12-18

编辑：Stephen23 2021-12-18

Of course, you can MKDIR a new directory.

But using CD is slow and make debugging more complex. It is NOT required to change directories just to import/export data files: using absolute/relative filenames is a much better approach (you will need to use FULLFILE).

请先登录，再进行评论。

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

Answer 1

Image Analyst 2021-12-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1613775-creating-automatically-a-folder-name-and-cd-the-folder-based-on-excel-file-name#answer_857910

在 MATLAB Online 中打开

Try something like (untested):

T = readtable('Iraq.xlsx') ; % Read file into table variable.
% Create folders for every city.
for row = 1 : height(T)
    thisCity = T.city{row}; % Get the ciry stored in this row of the table.
    folder = fullfile(pwd, thisCity); % Or any other folder instead of pwd.
    if ~isfolder(folder) % If the folder doesn't already exist, create it.
        fprintf('Creating new folder %s.\n', folder);
        mkdir(folder);
    end
end