Working with Excel Tables and Importing them.

After I import the table from Excel, how can I make a new table with only the names of the columns that you input somewhere?

Answer 1

[Walter Roberson]

mask = ismember(YourTable.Properties.VariableNames, ListOfColumnsYouWant);
NewTable = YourTable(:,mask);

[Minjun Seo]

Thank you, but If I wanted multiple columns, do I seperate each column with a comma?

[Walter Roberson]

Here, YourTable stands for the name of your table. Properties and VariableNames are literal things to put in. ListOfColumnsYouWant would be a cell array of character vectors.

>> T = array2table(randi(9,4,3))

T =

  4×3 table

    Var1    Var2    Var3
    ____    ____    ____

     2       5       8  
     9       8       9  
     2       8       5  
     3       2       7  

>> T.Properties.VariableNames

ans =

  1×3 cell array

    {'Var1'}    {'Var2'}    {'Var3'}
    
>> ListOfColumnsYouWant = {'Var3', 'Var1'};
>> mask = ismember(T.Properties.VariableNames, ListOfColumnsYouWant);
>> NewTable = T(:,mask)

NewTable =

  4×2 table

    Var1    Var3
    ____    ____

     2       8  
     9       9  
     2       5  
     3       7