How to import numerous excel files into MATLAB?
显示 更早的评论
A have several excel files that I need to modify through MatLab and export into a different folder. I need help with importing and exporting an entire folder of excel files.
Thanks,
-Frank
source_dir = 'C:\Users\xuf\Desktop\Excel Saved PointScans'
dest_dir = 'C:\Users\xuf\Desktop\Test Folder'
source_files = dir(fullfile(source_dir, '*.xls'));
for i = 1:length(source_files)
data = xlsread(fullfile(source_dir,source_files(i).name));
xlswrite(fullfile(dest_dir,source_files(i).name));
end
采纳的回答
Will Dampier
2011-5-10
You won't be able to load them all at once but you could easily use a for-loop to process them one at a time. Something like this:
source_dir = 'path/to/source/'
dest_dir = '/path/to/dest'
source_files = dir(fullfile(source_dir, '*.xls'));
for i = 1:length(source_files)
data = xlsread(fullfile(source_dir, source_files(i).name)));
#do something with data
xlswrite(fullfile(dest_dir, source_files(i).name)));
end
14 个评论
Frank
2011-5-10
Andy
2011-5-10
No. That argument to the dir function tells it to return all files ("all" symbolized by the *) with extension .xls. Perhaps it would be helpful to read the documentation for dir by typing:
doc dir
at the command line.
Frank
2011-5-10
Oleg Komarov
2011-5-10
Edit your original post adding the code formatted with the "{} code" button.
Frank
2011-5-10
Oleg Komarov
2011-5-10
Did you substitute 'path/to/source' and 'path/to/dest' with the paths of interest?
Frank
2011-5-10
Oleg Komarov
2011-5-10
Did you get an error?
Frank
2011-5-10
Andy
2011-5-10
You can see the help for xlswrite by typing "doc xlswrite" at the command line. You would see that xlswrite takes two arguments: the file and the variable to be stored. So you should change that line to:
xlswrite(fullfile(dest_dir,source_files(i).name), data);
Frank
2011-5-10
Jeong_evolution
2016-7-4
But this code just imported numeric data.
I want to import from numeric to txt data.
[num txt raw] = xlsread('') is just imported only 1 files.
What should I do?
Image Analyst
2016-7-4
You need to pass it a filename. You need to call it multiple times if you have multiple filenames.
Nicolò Biagi
2018-2-22
can you give us an example on how to do it?
Thanks
更多回答（2 个）
Michael Chavez
2015-2-20
1 个投票
This has been a helpful thread for a project that I am working on. So thank you, Frank, for asking it and thank you to all that have responded.
I would like to add and ask is it possible to change the names of the output files from xlswrite, rather than the output file being the same name as the corresponding input file?
Arnaud, I was looking at the documentation for dir and I'm not sure that I saw how to generate a name for the list of output files or maybe I am overlooking the function to change the name. I am using MATLAB 7.8.0 (R2009a) for the record.
Arnaud Miege
2011-5-10
0 个投票
HTH,
Arnaud
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
