how to import an excel or txt file with multiple columns of 'strings'
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Walter Roberson
2012-7-3
Possibly
[num, txt] = xlsread('YourFile.xls');
Then txt should be the cell array.
2 个评论
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.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!