Specify format when using readtable() to read spreadsheet .xlsx?

Question

Isabel Chen 2016-8-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/298429-specify-format-when-using-readtable-to-read-spreadsheet-xlsx

回答： Peter Perkins 2016-8-4

采纳的回答： Peter Perkins

在 MATLAB Online 中打开

Suppose my spreadsheet data.xlsx has a column of strings:

'abc', 'def', 'ghi'

Calling

myTable = readtable(data.xlsx)

puts each string into a cell array, like so:

{'abc'}, {'def'}, {'ghi'}.

The data cannot be accessed in the usual way, eg,

rows = myTable.Var1 == 'abc'

What I would like is each entry to be a string, without the cell-array wrapper. When I use the 'Format' option:

readtable(data.xlsx,'Format','%s'),

I get an error message:

Error using readtable (line 143). 
Invalid parameter name: Format.

so it seems that the 'Format' option is not available for spreadsheets. Is this the case, or am I doing something wrong?

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

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2016-8-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/298429-specify-format-when-using-readtable-to-read-spreadsheet-xlsx#answer_230791

Cell arrays are the standard way to store strings in MATLAB. You may or may not be asking about character matrices, but you really don't want to be using those. Seeing myTable.Var1 == 'abc' in your post makes me think you may be asking about categorical arrays. It's easy to convert a cell array of strings to categorical, but you can't read directly to categorical from a spreadsheet.