reading an combining excel files

Question

Lotte Piek 2023-2-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907050-reading-an-combining-excel-files

评论： Lotte Piek 2023-2-6

Hi everyone,

I have a folder with excel files with I would all like to load in and combine. Is this a possibility? I want to prevent loading them in one-by-one and then combining them one-by-one since it contains around a 100 excel files with all just one row of heading and one row of data.

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

请先登录，再进行评论。

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

Answer 1

Sulaymon Eshkabilov 2023-2-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907050-reading-an-combining-excel-files#answer_1164445

在 MATLAB Online 中打开

There are a few different ways to get this task done. One of them is this one if your data files have the same number of numerical data sets (there is just one row of data in each file you stated):

FILE = fullfile('C:\Users\...', '*.xlsx');  % Directory where the files are residing. 
LIST = dir(FILE);
N = length(LIST);                          % N number of files 
Ncols = ???                                % Ncols how many columns of data in 
D = zeros(N, Ncols);
for ii = 1 : N   
    FFName = fullfile(LIST(ii).folder, LIST(ii).name);
    DATA = readmatrix(FFName);                
    D(ii, :) = DATA;                    % NOW D contains all data from 100 files
end

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

Lotte Piek 2023-2-6

thank you very much! Would it be a possibility to keep the header ?

请先登录，再进行评论。

Answer 2

Vineeta Shukla 2023-2-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1907050-reading-an-combining-excel-files#answer_1164450

编辑：Vineeta Shukla 2023-2-6

Hi,

From my understanding, you can use the function spreadsheetDatastore to manage and import the data when you have data stored across multiple spreadsheet files.

Here is an example from documentation:

https://www.mathworks.com/help/matlab/import_export/read-a-sequence-of-spreadsheet-files.html

Here is a link to the documentation to understand more about spreadsheetDatastore: https://www.mathworks.com/help/matlab/ref/matlab.io.datastore.spreadsheetdatastore.html