Put excel collumns in an array

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 !

Answer 1

[Saurav Roy]

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

[Lucas S]

Yes thank you !