How to read numerics as strings with readtable?

Question

Leon 2020-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509032-how-to-read-numerics-as-strings-with-readtable

评论： Al in St. Louis 2021-4-21

I have a table in spreadsheet (xlsx). One of the column is composed of either a numerical number, or several of them, like the below:

When I use readtable:

T1 = readtable ('Observations.xlsx');

the results are like this:

2
3 
NaN
9
7
4
NaN
5

My question is how do I read the info as a string, so that the groups like '5,7', and '2,8,9' are all captured?

I tried:

T1 = readtable ('Observations.xlsx', 'Format','%s %s %s');

But got the below error:

Invalid value for "Format". Must be "auto" for spreadsheet files.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ruger28 2020-3-4

编辑：Ruger28 2020-3-4

在 MATLAB Online 中打开

Strange, I copied and pasted your values into excel, used readtable, and got this:

T =
  7×1 table
      x2   
    _______
    '3'    
    '5,7'  
    '9'    
    '7'    
    '4'    
    '2,8,9'
    '5'
    

Can you share you .xlsx file? I am assuming it is a number format issue.

请先登录，再进行评论。

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

Answer 1

Guillaume 2020-3-4

10
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/509032-how-to-read-numerics-as-strings-with-readtable#answer_418537

在 MATLAB Online 中打开

opts = detectImportOptions(yourfile);
opts = setvartype(opts, whichevervariable, 'string');  %or 'char' if you prefer
data = readtable(yourfile, opts)

Where whichevervariable is a char vector, cell array of char vector, string array containing the name(s) of the variable(s) that must be read as string/char or a numeric vector of variable indices.