Converting string matrix from Excel to Matlab
显示 更早的评论
I have an excel document containing a matrix of strings (that is, each cell contains a word of varying length). If possible, I want to read this into Matlab so that I have a matrix of strings just as it is in Excel. In particular, I need to be able to reference the (i,j)th matrix element, which should contain an individual word/string.
For example, if cell A2 in excel contains "dog," I would like element (1,2) in matlab to contain the string 'dog'.
It seems like there should be a quick way to do this, but I can't get anything to work. Does anyone have any ideas? Let me know, thanks!!
采纳的回答
Laura Proctor
2011-4-12
Use XLSREAD with three outputs. The final output, raw, will contain a cell array with all of your data from Excel.
[num,txt,raw] = xlsread(filename)
A2 = raw{1,2}; % Will assign the element to variable A2
更多回答（1 个）
Walter Roberson
2011-4-12
0 个投票
If you are on a Windows machine and have Excel installed, then xlsread() should be able to return the data in the form of cell arrays. You would need to use element{1,2} instead of element(1,2) but that adjustment should not be difficult.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
