how do i combine multible excel file into single file using matlab?

Question

ahmed obaid 2017-5-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341723-how-do-i-combine-multible-excel-file-into-single-file-using-matlab

评论： Daphne PARLIARI 2020-3-12

Dear experiences ...

I have many excel file in certain folder 100+ (D:\source), where these files are named in the following structre {0.xlsx, 1.xlsx,2.xlsx, ....etc}, all excel files havin the following columns contents look like the following ..

No  Index  File Name
6  2012-07-20-18-23-02
7  3097-success-edit
8  2012-07-20-18-30-44
11  2012-large-columns
13  2012-admins-logs
etc..

so i need to combine all these files into single excel file involve the following contents:

Id  Index  File Name              file_label
6  2012-07-20-18-23-02     0
7  3097-success-edit       0
8  2012-07-20-18-30-44     0
11  2012-large-columns      1
13  2012-admins-logs        1

where ID here is numeric count for the rows, index whatever extracted from every excel file, File name whetever extracted from every file, and finally labels is give value based on file name, in the above example for the file names that extracted from 0.xlsx file its give an (0) values to all file names that comes from this 0.xlsx file, and (1) for the file names that comes from 1.xlsx file, and (2) for the file names that come from 2.xlsx file and so on..

i would thank any one can help me in this issue.

thanks

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2017-5-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/341723-how-do-i-combine-multible-excel-file-into-single-file-using-matlab#answer_268227

在 MATLAB Online 中打开

Assuming your excel files all have consistent header, this should be fairly simple to achieve:

path = 'D:\source';
files = dir(fullfile(path, '*.xlsx'));
result = table();         
for fidx = 1:numel(files)
   filecontent = readtable(fullfile(path, files(fidx).name)); 
   [~, filenumber] = fileparts(files(fidx).name);
   filecontent.file_label = repmat(str2double(filenumber), height(filecontent), 1);
   result = [result; filecontent];
end

3 个评论
显示 1更早的评论隐藏 1更早的评论

Kasih Ditaningtyas Sari Pratiwi 2017-11-11

在 MATLAB Online 中打开

Hi Guillaume. I want to ask about how to merge multiple xls files into a single file with the same worksheet. I read some questions which also have the same problem, but mostly the resulted file has separate worksheets. In my case, I want to merge the table so that it only has one worksheet. I try this code below:

%%Merge multiple XLS files into one XLS file
[files,dir] = uigetfile('*.xls','Select Files','MultiSelect','on');
output = fullfile(folder,'rainfall.xls');
addpath(dir);
for i = 1:numel(files)
    ftab = readtable(files{i});
    writetable(ftab,output,'Sheet',filenames{i});
end

but of course it has separated worksheets. I want to make it in one worksheet as the files have also the same structure so it should be easily to merge. Do you know what should I modify in my code above? Thank you very much. I really appreciate for your help.

Daphne PARLIARI 2020-3-12

在 MATLAB Online 中打开

Hey Guillaume.

I tried your code (thanks for that!) and for me, it stops in the 6th line with the error "Dot indexing is not supported for variables of this type.".

The code I am trying:

path = append(output_path,'\',stations{i},'\');
files = append(path, 'Stats ', months ,' ', stations{i} ,' ',vars{1},' .csv'); 
%files = string(files);
%str = char(files);
result = table();         
for fidx = 1:numel(files)
   filecontent = readtable(files{fidx}); 
   [~, filenumber] = fileparts(files(fidx).name);
   filecontent.file_label = repmat(str2double(filenumber), height(filecontent), 1);
   result = [result; filecontent];
end