how to import an excel or txt file with multiple columns of 'strings'

Question

George McFadden 2012-7-3

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42588-how-to-import-an-excel-or-txt-file-with-multiple-columns-of-strings

I have an excel file with 347 rows and 5 columns of strings. Each string in a cell has single quotes around it. For example:

'FS-SW 7/27'     'frogstool'    'fs3'    'center'    'recon'
'FS3-10'  'frogstool'  'fs3'  'center'  'recon'
'FS3-26'  'frogstool'  'fs3'  'center'  'recon'
'PUN-SW 7/27'  'pungos'  'pun1'  'center'  'recon'
'PUN1-10'  'pungos'  'pun1'  'center'  'recon'
'PUN1-23'  'pungos'  'pun1'  'center'  'recon'

How do I load this into Matlab as a cell array ideally? I need the data to be entered in the same matrix dimensions, (347,5). I am going to horizontally concatenate it with a numeric array into a dataset eventually.

Thanks in advance!

-1waytimemachine

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2012-7-3

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/42588-how-to-import-an-excel-or-txt-file-with-multiple-columns-of-strings#answer_52414

在 MATLAB Online 中打开

Possibly

[num, txt] = xlsread('YourFile.xls');

Then txt should be the cell array.

2 个评论
显示无隐藏无

George McFadden 2012-7-3

> Walter, xlsread worked, thank you! I used [txt,raw] = xlsread...

The text variable contains nothing, but the raw contains the data. Load, and import data were not working for me. Thanks again.

Walter Roberson 2012-7-3

Selection of output is positional, not by variable name. The first output of xlsread() is always the numeric array, even when no understandable numbers were found.

请先登录，再进行评论。