Extracting character from an excel file

6 次查看（过去 30 天）
pradeep kumar
pradeep kumar 2014-9-28
评论： pradeep kumar 2014-9-28
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

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2014-9-28
The simplest way, would probably be to use readtable and get your data as a table:
t = readtable('data.xlsx');
  2 个评论
Image Analyst
Image Analyst 2014-9-28
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 2014-9-28
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

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by