Extracting character from an excel file

6 vues (au cours des 30 derniers jours)
pradeep kumar
pradeep kumar le 28 Sep 2014
Commenté : pradeep kumar le 28 Sep 2014
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

Connectez-vous pour répondre à cette question.

Réponse acceptée

Guillaume
Guillaume le 28 Sep 2014
The simplest way, would probably be to use readtable and get your data as a table:
t = readtable('data.xlsx');
  2 commentaires
Image Analyst
Image Analyst le 28 Sep 2014
Then, if for some reason you want to break them out separately, do...
name = t.Name;
age = t.age;
I agree this is the best way. You can use tables if you have R2013b or later. If not, (UPGRADE!) then you can use xlsread().
pradeep kumar
pradeep kumar le 28 Sep 2014
i have used xlsread(data.xlsx) , but its only extracting the numerical values ,but i want to obtain both as mentioned above . Please help me out

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Cell Arrays dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by