MATLAB: Put excel collumns in an array

importing excel dataMATLAB

Hello !

I have never used excel parser in Matlab. I have an excel file which have 3 columns. And i would like to save all elements of column 2 in an array and all elements of column 3 in an other array. How can i browse the excel file column by column and then line by line ?

Thank you !

Best Answer

Hey !

I hope this is what you are looking for....

% Read Excel Sheet

[~,~,data] = xlsread('Add path to the excel file (.xlsx)');

% Save columns

arraycolumn2 = data(:,2); % Parse column 2

arraycolumn3 = data(:,3); % Parse column 3

Related Solutions

MATLAB: Adding Data Already Existing Excel Sheets

Try writematrix

writematrix(M,'Sample.xlsx','Sheet',1,'Range','D3:D6')

MATLAB: Table: Add only selected collumns

1. Create the full table first, however you were going to create it:

name = {'Joe'; 'Elisa'; 'John'};
age = [30; 10; 25];
weigth = [100; 150; 180];       %note that weigth is mispelled, should be weight
t = table(name, age, weight)

2. use logical indexing to select the columns you want:

selected = [1, 0, 1];
selected = logical(selected); 
%or create it directly as logical:
%selected = [true, false, true];
filteredtable = t(:, selected)  %only keep selected columns

Best Answer

Related Solutions

MATLAB: Adding Data Already Existing Excel Sheets

MATLAB: Table: Add only selected collumns

Related Question