Converting string matrix from Excel to Matlab

11 次查看（过去 30 天）
John
John 2011-4-12
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
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
Walter Roberson 2011-4-12
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.
  1 个评论
John
John 2011-4-12
Unfortunately I'm working on a mac laptop. Is there any way to do this with a mac?

请先登录，再进行评论。

类别

在 Help Center 和 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