How to export Excel files to the specific folder?

15 次查看（过去 30 天）
BN
BN 2020-1-15
评论： Adam Danz 2020-1-15
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
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 个评论
显示 4更早的评论
BN
BN 2020-1-15
oh, it's done. really appreciate. I edited it and it's worked well.
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},fullfile(out_dir, baseFileName))
end
end
Thank you for your time and help :)
Adam Danz
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
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 个评论
BN
BN 2020-1-15
Dear Jakob B. Nielsen
I tried this code that you wrote, but I don't know why it didn't work for me.
Thank you
Adam Danz
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 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by