MATLAB: How to import excel data as separate column vectors

column vectorexcelimport excel dataseparate vectors

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

Best Answer

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.

Related Solutions

MATLAB: Legend when plotting with while

This may work.

    clc
clear all
 T = readtable('Book1.xlsx');
 Time=T.DateTime;
 ColumnYouNeed = input('Which variable would you like to plot: ','s');
mask = ismember(T.Properties.VariableNames,ColumnYouNeed);
NewTable = table2array(T(:,mask));
 plot(Time,NewTable)
 hold on
 legend(ColumnYouNeed)
 a=input('Would you like to plot another variable? ','s');
cc=2;
 while a=='yes'
    ColumnYouNeed(cc) = input('Which variable would you like to plot: ','s');
    mask = ismember(T.Properties.VariableNames,ColumnYouNeed);
    NewTable = table2array(T(:,mask));
    plot(Time,NewTable)
    legend(ColumnYouNeed)
    a=input('Would you like to plot another variable? ','s'); 
 cc = cc +1;
end

MATLAB: Can user choose desired column data from excel to matlab

Well I imagine the user needs to see the data before making the decision about which column to import. So they either do that in Excel in advance and then you ask them in MATLAB, or you haul the whole workbook into MATLAB and display in a uigrid control and then ask them. You can ask them via inputdlg(), like this snippet:

% Ask user for a number.
defaultValue = 45;
titleBar = 'Enter a number';
userPrompt = 'Enter the column number';
caUserInput = inputdlg(userPrompt, titleBar, 1, {num2str(defaultValue)});
if isempty(caUserInput),return,end; % Bail out if they clicked Cancel.
% Round to nearest integer in case they entered a floating point number.
integerValue = round(str2double(cell2mat(caUserInput)));
% Check for a valid integer.
if isnan(integerValue)
    % They didn't enter a number.  
    % They clicked Cancel, or entered a character, symbols, or something else not allowed.
    integerValue = defaultValue;
    message = sprintf('I said it had to be an integer.\nI will use %d and continue.', integerValue);
    uiwait(warndlg(message));
end

If they enter column letters, you'll need to use this: http://blogs.mathworks.com/pick/2010/04/16/from-excel-column-labels-to-numbers/

Best Answer

Related Solutions

MATLAB: Legend when plotting with while

MATLAB: Can user choose desired column data from excel to matlab

Related Question