Import excel file!

1 次查看（过去 30 天）
ck
ck 2016-6-2
回答： Star Strider 2016-6-2
So I have to import data from a excel file (xx.csv), it has data types as character and Ascii-real. I used num=xlsread(filename), this opens the columns with numbers . How do I open columns with data type as character??

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

回答（1 个）

Star Strider
Star Strider 2016-6-2
To retrieve the string or non-numeric data, use two outputs from xlsread:
[num, str] = xlsread(filename);
The ‘num’ variable will have the numeric values, and the ‘str’ variable will have the non-numeric (character) values as a cell array.

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by