How to read numerics as strings with readtable?

274 次查看（过去 30 天）
Leon
Leon 2020-3-4
评论： 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:
2
3
5,7
9
7
4
2,8,9
5
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 个评论
Ruger28
Ruger28 2020-3-4
编辑：Ruger28 2020-3-4
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.

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2020-3-4
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.
  2 个评论
Leon
Leon 2020-3-4
Works well. Exactly what I need!
Thank you so much!
Al in St. Louis
Al in St. Louis 2021-4-21
Given that Mathworks has broken readtable, it's good that they have provided this workaround so that we can keep using our data.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by