I have an excel file containing text and numbers, xlsread not import the columns containing text. what should I do?

Question

Arash Alvankar 2015-2-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/174871-i-have-an-excel-file-containing-text-and-numbers-xlsread-not-import-the-columns-containing-text-wh

回答： Zahra Sharifnezhadazizi 2018-12-30

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Michael Haderlein 2015-2-3

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/174871-i-have-an-excel-file-containing-text-and-numbers-xlsread-not-import-the-columns-containing-text-wh#answer_166824

在 MATLAB Online 中打开

It does, it just returns it in another parameter. From Matlab help:

[ndata, text, alldata] = xlsread('myExample.xlsx')
ndata =
     1     2     3
     4     5   NaN
     7     8     9
text = 
    'First'    'Second'    'Third'
    ''         ''          ''     
    ''         ''          'x'    
alldata = 
    'First'    'Second'    'Third'
    [    1]    [     2]    [    3]
    [    4]    [     5]    'x'    
    [    7]    [     8]    [    9]