Using a Loop to read and store information?

Question

Gabriela Garcia 2021-1-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/716473-using-a-loop-to-read-and-store-information

评论： Walter Roberson 2021-1-15

I have data stored in 10 different excel documents. Each document has the same table-like format. My goal is to read the information I want to use from the excel data, load it into my script, and reorganize it into a new excel sheet. For this question, I want to know if there is a way that I can use a while or for loop to load my data, rather than type out load for each document.

Each excel document is titled in ascending order, such as 'a1', 'a2' ... 'a10'

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-1-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/716473-using-a-loop-to-read-and-store-information#answer_597573

http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Or potentially you could use a datastore()

2 个评论
显示无隐藏无

Gabriela Garcia 2021-1-15

This helped me to load the data, thank you!

But I was not clear that I wanted this data in a table or matrix format so that I might compare them. I am relatively new to Matlab, so I am not sure if I can use this function to also read each excel as a matrix within the loop?

Walter Roberson 2021-1-15

在 MATLAB Online 中打开

https://www.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort

dinfo = dir('a*.xlsx');
filenames = {dinfo.name};
filenames = natsortfiles(filenames);
numfiles = length(filenames);
datacell = cell(numfiles,1);
for K = 1 : numfiles
    datacell{K} = readmatrix(filenames{K});
end