How do I import data files to column vectors in a loop?

Question

Eveline 2015-3-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/181655-how-do-i-import-data-files-to-column-vectors-in-a-loop

评论： Eveline 2015-3-5

Hello,

I'm trying to import some data from different .xlsx files into column vectors in Matlab. All files look the same, only the values are different.

Right now Matlab only shows me one vector of each (A,B,C,D,..). I need to have the vectors A,B,C,.. for all files that I read. For example A1,A2,A3,B1,B2,B3,...

Can anyone help me?

Thanks in advance!

---------------------------------

In the code below I make use of a Matlab generated code to import the file into a column vector.

numFiles = 3;
range = 'A1:G100';
sheet = 1;
for fileNum = 1:numFiles
    fileName = sprintf('document%1d.xlsx',fileNum);
    [A,B,C,D,E,F,G] = importfile(fileName,sheet,range);
end

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

请先登录，再进行评论。

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

Answer 1

Michael Haderlein 2015-3-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/181655-how-do-i-import-data-files-to-column-vectors-in-a-loop#answer_170172

在 MATLAB Online 中打开

I don't know your importfile function, but in general you can do it the following way:

for fileNum = 1:numFiles
    fileName = sprintf('document%1d.xlsx',fileNum);
    [A(:,fileNum),B(:,fileNum),C(:,fileNum),D(:,fileNum),E(:,fileNum),F(:,fileNum),G(:,fileNum)] = importfile(fileName,sheet,range);
end

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

Eveline 2015-3-5

Thanks a lot, this helped me out! :)

请先登录，再进行评论。

Answer 2

Stephen23 2015-3-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/181655-how-do-i-import-data-files-to-column-vectors-in-a-loop#answer_170171

编辑：Stephen23 2015-3-5

在 MATLAB Online 中打开

Save the data in cell arrays like this:

numFiles = 3;
range = 'A1:G100';
sheet = 1;
for k = 1:numFiles
    fileName = sprintf('document%1d.xlsx',k);
    [A{k},B{k},C{k},D{k},E{k},F{k},G{k}] = importfile(fileName,sheet,range);
end

You can access the data using the same cell array indexing, e.g. to refer to the A data from the fourth file use this:

A{4}

In case you were wondering, it is considered poor practice to dynamically name variables like name1, name2, name3, etc. See this for an explanation of why:

http://de.mathworks.com/matlabcentral/answers/180604-loop-on-dynamic-variable