MATLAB: Extracting character from an excel file

cell arrayimporting excel datamatrixmatrix manipulationstring

Hello everyone . Suppose i have an excel file (data.xlsx) , which contains the following data.
Name age
Tom 43
Dick 24
Harry 32
Now i want to extract the data from it and make 2 cell array (or matrix) which will contain
name = ['Tom' ; 'Dick';'Harry']
and age = [43;24;32] .
Please help me . how efficiently i obtain this . Thanks in advance

Best Answer

The simplest way, would probably be to use readtable and get your data as a table:
t = readtable('data.xlsx');