path = 'C:\Users\asus-ps\Desktop\TEMP\'; fileExtension = '*.xlsx'; files = dir(fullfile(path,fileExtension)); len = size(files,1); for ii = 1:len fileName = strcat(path,files(ii,1).name) end

for ii = 1:len fileName = strcat(path,files(ii,1).name); data = xlsread(fileName) end

values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9};
headers = {'First','Second','Third'};
xlswrite('myExample.xlsx',[headers; values]);

filename = 'myExample.xlsx';
A = xlsread(filename)

filename = 'myExample.xlsx';
sheet = 1;
xlRange = 'B2:C3';
subsetA = xlsread(filename,sheet,xlRange)

filename = 'myExample.xlsx';
columnB = xlsread(filename,'B:B')

[num,txt,raw] = xlsread('myExample.xlsx')

load patients.mat
T = table(LastName,Age,Weight,Smoker);
T(1:5,:)

filename = 'patientdata.xlsx';
writetable(T,filename,'Sheet',1,'Range','D1')

writetable(T,filename,'Sheet',2,'WriteVariableNames',false)

3楼: Originally posted by young_sir at 2018-06-03 22:49:29
1）如何批量导入大量命名无规律的excel文件

     Matlab可以做到遍历当前文件夹下面的所有文件。举例：我在桌面上建立一个TEMP的文件夹，并把楼主给的4个xlsx都放到其中。然后通过下面的循环读出所有后缀为'xlsx ...

4楼: Originally posted by FMStation at 2018-06-05 08:06:49
https://www.mathworks.com/help/matlab/ref/xlsread.html


values = {1, 2, 3 ; 4, 5, 'x' ; 7, 8, 9};
headers = {'First','Second','Third'};
xlswrite('myExample.xlsx',);

filename = 'myExample.xls ...

>> [n, files] = get_folder_content( 'c:/A123/', 'myEx', 0, '');

Folder contain files for further processing:
1 file: myEx01.xlsx
2 file: myEx0A.xlsx
3 file: myExCC1.xlsx
Number of listed files: 3

>> allFiles=strvcat(files.name)

allFiles =
myEx01.xlsx
myEx0A.xlsx
myExCC1.xlsx

>> allFiles(1,:)

ans =
myEx01.xlsx


%%%%%%%%%%%%%%%%%
       get_folder_content
%%%%%%%%%%%%%%%%%
% Function return the folder content filtered
% function [ n, datafiles ] = get_folder_content( directory, filepattern, filterout, fpattern)
%
% input:
% - directory
% - filepattern
% - filterout | 1 or 0
% - fpattern | not include files with this pattern
% fpattern is charracter array created by fpattern =
% char('string1', 'string2', ...,'stringn');
% or in case of one string fpattern = 'string';
%
% output:
% - n | number of files
% - datafiles | structure with datafiles
% datafiles(i).name -- sigle file name
% datafiles(i).fullname -- including full path
function [ n, datafiles ] = get_folder_content( directory, filepattern, filterout, fpattern)
%initialisation of the structure
datafiles(1).name = '';
datafiles(1).fullname = '';
if nargin <3,
filterout = 0;
end
tmpdir = dir([directory filepattern '*']);
nn = length(tmpdir);
%filtering not necessary files
cnt = 0;
display('Folder contain files for further processing:')
if filterout==1
[nstr s] = size(fpattern);
filter_flag = 0;
for i=1:nn
for st=1:nstr
S = regexp(tmpdir(i).name,fpattern(st,:));
if(isempty(S))
filter_flag=0;
else
filter_flag=1;
end
end
if(filter_flag==0)
% filter pattern not maching ... so this is correct file
cnt = cnt+1;
datafiles(cnt).name = tmpdir(i).name;
datafiles(cnt).fullname = [directory tmpdir(i).name];
else
%filter pattern matching
%display(['Filtering out: ' tmpdir(i).name ' file'])
end
end
else
for i=1:nn
datafiles(i).name = tmpdir(i).name;
datafiles(i).fullname = [directory tmpdir(i).name];
end
end
n = length(datafiles);
for i=1:n
display([ num2str(i) ' file: ' datafiles(i).name ])
end
display(['Number of listed files: ' num2str(n)]);
return

7楼: Originally posted by FMStation at 2018-06-06 17:50:47
1. 如何批量导入大量命名无规律的excel文件


&gt;&gt;  = get_folder_content( 'c:/A123/', 'myEx', 0, '');

Folder contain files for further processing:
1 file: myEx01.xlsx
2 file: myEx0A. ...

[files,folder] = uigetfile('*.xls','Select Files','MultiSelect','on');

N=[];
for i=1:numel(files)
myName=fullfile(folder,files{i})
A = xlsread(myName);
N = [N;A];
end

N2 = sortrows(N,[2,3,4]);
xlswrite('c:/myExample.xlsx',N2);

5楼: Originally posted by yangyong177 at 2018-06-06 10:42:47
非常感谢您的回复。前两天有事，忘记感谢您了。
不过还有两个问题请教：1）按照你的代码批量代入后，matlab中只有最后一个excel文件数据，其他三个都没有？
  2）第二步，合成一个文件依然不会处理，请您指教，能 ...