Put excel collumns in an array

4 views (last 30 days)
Lucas S
Lucas S on 28 Apr 2020
Commented: Lucas S on 28 Apr 2020
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 !

Accepted Answer

Saurav Roy
Saurav Roy on 28 Apr 2020
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

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!