How to export Excel files to the specific folder?
조회 수: 28 (최근 30일)
이전 댓글 표시
I have the below code:
for p = 1:numel(C)
filename = C{p}{1,2};
if ~isempty(filename{:})
sprintf('%s.xlsx',filename{:})
writetable(C{p},sprintf('%s.xlsx',filename{:}))
end
end
I want to save all excel files generated in this code to "E:\AZAR\xlsx files 1989-2018" instead of the current folder. does anyone have an idea for how to do it?
Thank you all.
채택된 답변
Adam Danz
2020년 1월 15일
Use the fullPath = fullfile(path, filename) function to create full paths to files. This offers a number of very important benefits over simply concatenating strings to produce a full path. From the documentation,
- fullfile inserts platform-dependent file separators where necessary (on Windows platforms it's a backslash \).
- and it replaces all forward slashes (/) with backslashes (\) on Windows.
- It also smartly concatenates string by collapsing inner repeated file separators.
directory = 'E:\AZAR\xlsx files 1989-2018';
filename = 'data.xlsx';
writetable(C{p},fullfile(directory,filename));
댓글 수: 6
Adam Danz
2020년 1월 15일
No problem!
Note the small improvement made below ( see arrow).
out_dir='E:\AZAR\Prepared xlsx files 1989-2018';
for k = 1:numel(C)
filename = C{k}{1,2};
if ~isempty(filename{:})
baseFileName = sprintf('%s.xlsx',filename{:});
fullFileName = fullfile(out_dir, baseFileName);
writetable(C{k},fullFileName) %<--------------
end
end
추가 답변 (1개)
Jakob B. Nielsen
2020년 1월 15일
You can find the answer in the documentation for the writetable function. You must simply format your filename to be E:\AZAR\xlsx files 1989-2018\yourname.xlsx, for example using the strcat function, like;
strcat('E:\AZAR\xlsx files 1989-2018',sprintf('%s.xlsx',filename{:})));
댓글 수: 2
Adam Danz
2020년 1월 15일
It looks like the backslash may be missing between the path and filename.
Another possibility is that your platform expects a different path format.
These problems are all solved by using the fullfile() function.
참고 항목
카테고리
Help Center 및 File Exchange에서 Search Path에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!