combine or merge multiple excel files into one file.

Question

mirewuti muhetaer 2020-3-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513655-combine-or-merge-multiple-excel-files-into-one-file

回答： Walter Roberson 2020-3-29

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

hi, i have 100 excel files and they have one of the three following types.

type1:

name    id     2010 2011 2012 2013 2014 2015 2016 2017 2018 2019
david     a
james    a
tome     a
alim       a

type2:

name    id     2010 2011 2012 2013 2014 2015 2016 2017 2018
david     a
james    a
tome     a
alim       a

type3:

name    id     2011 2012 2013 2014 2015 2016 2017 2018 2019
david     a
james    a
tome     a
alim       a

is there any way that i can combine all of the 100 files into one by using simple loop or any other feasible way?.

Thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2020-3-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513655-combine-or-merge-multiple-excel-files-into-one-file#answer_422608

在 MATLAB Online 中打开

name = cell(0,0); id = cell(0,0); 
x2010 = []; x2011 = []; x2012 = []; x2013 = []; x2014 = []; x2015 = []; x2016 = []; x2017 = []; x2018 = []; x2019 = [];
result = table(name, id, x2010, x2011, x2012, x2013, x2014, x2015, x2016, x2017, x2018, x2019);
dinfo = dir('*.xlsx');
nfiles = length(dinfo);
for K = 1 : nfiles
    thistable = readtable(result, 'readvariablenames', true);
    thisvars = thistable.Properties.VariableNames;
    if ~ismember( 'x2010', thisvars)
        thistable.x2010 = nan(height(thistable),1);
    end
    if ~ismember( 'x2019', thisvars)
        thistable.x2019 = nan(height(thistable,1));
    end
    result = [result; thistable];   %will automatically rearrange variables to match first table
end