how to import excel data as separate column vectors?

30 次查看（过去 30 天）

Viktor G. 2020-2-29

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/508206-how-to-import-excel-data-as-separate-column-vectors

评论： Star Strider 2020-3-1

Hey guys,

can someone please tell me how to import excel data as separate column vectors? I know how to do it trough the interface but i need to use it in a script :/

Thank you for your help

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

请先登录，再进行评论。

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

采纳的回答

Star Strider 2020-2-29

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/508206-how-to-import-excel-data-as-separate-column-vectors#answer_417839

The available functions inport Excel files as matrices (that are of course collections of column vectors) are readmatrix and xlsread. There are others such as readtable, however that imports them as table objects.

11 个评论
显示 9更早的评论隐藏 9更早的评论

Star Strider 2020-2-29

在 MATLAB Online 中打开

Create a cell array of ‘ColumnYouNeed’ and the legend entries work correctly:

T = array2table(sortrows(randi(99,10,5),1), 'VariableNames',{'Time','Temperature','Humidity','BaroPres','DewPt'});
Choose = @(col) T(:,strcmp(T.Properties.VariableNames,col));
ColumnYouNeed{1} = input('which column do you need? ' ,'s');            % Create AS Cell Array Elements
C = Choose(ColumnYouNeed{1});
plot(T.Time, table2array(C))
grid
legend(ColumnYouNeed{1})                                      
hold on
answer=input('Would you like to also plot another column? ','s');
if strcmp(answer, 'yes')
    ColumnYouNeed{2} = input('which column do you need? ' ,'s');
    C = Choose(ColumnYouNeed{2});
    plot(T.Time, table2array(C))
    grid
    legend(ColumnYouNeed)
end

It might be best to just put all that in a loop, incrementing ‘ColumnYouNeed’, rather than having the first part outside the loop and the rest inside.

You could then exit the loop with:

if strcmp(answer, 'yes')
    ColumnYouNeed{2} = input('which column do you need? ' ,'s');
    C = Choose(ColumnYouNeed{2});
    plot(T.Time, table2array(C))
    grid
    legend(ColumnYouNeed)
    else
        return
end

I defer to you for that decision.

Star Strider 2020-2-29

编辑：Star Strider 2020-2-29

在 MATLAB Online 中打开

Try this:

T = array2table(sortrows(randi(99,10,5),1), 'VariableNames',{'Time','Temperature','Humidity','BaroPres','DewPt'});
Choose = @(col) T(:,strcmp(T.Properties.VariableNames,col));
k = 1;
answer = 'yes';
while strcmpi(answer,'yes')
    answer=input('Would you like to plot a column? ','s');
    if strcmpi(answer,'no')
        break
    end
    ColumnYouNeed{k} = input('which column do you need? ' ,'s');
    C = Choose(ColumnYouNeed{k});
    Col(:,k) = table2array(C);
    k = k + 1;
end
figure
plot(T.Time, Col)
grid
legend(ColumnYouNeed)

The logic worked when I ran it. Experiment to get different results.

EDIT — (29 Feb 2020 at 23:52)

This is much better and more efficient:

T = array2table(sortrows(randi(99,10,5),1), 'VariableNames',{'Time','Temperature','Humidity','BaroPres','DewPt'});
Prompt = {'Choose columns to plot: ','(Hold down CTRL to choose more than one)'};
List = T.Properties.VariableNames;
Colsc = listdlg('PromptString',Prompt, 'ListString',List(2:end), 'ListSize',[220 300])
Col = table2array(T(:,Colsc+1));
figure
plot(T.Time, Col)
grid
legend(List(Colsc+1))