9楼: Originally posted by FMStation at 2018-06-07 19:55:28
批量导入大量命名无规律的excel文件
按相同的日期sort
合成一个Big excel文件


= uigetfile('*.xls','Select Files','MultiSelect','on');

N=[];
for i=1:numel(files)
myName=fullfile(folder,files{i ...

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)