I would like to read strings into Matlab from an excel file
ID = xlsread('data.xlsx',1, 'D2:D4')
the cells in range D2:D4 have strings in them. When I try to import the strings into Matlab all I get is an empty list? what can I do to fix this?
views:
43answers:
2
+3
A:
I need to use this [num, txt, raw] = xlsread('data.xlsx',1, 'D2:D4')
the txt will import stings into Matlab.
Ben Fossen
2010-06-23 18:41:09
+4
A:
If you're in Matlab 2010 you can also do something like this to avoid having extra values in your workspace.
[~, ~, raw] = xlsread('data.xlsx',1, 'D2:D4')
JudoWill
2010-06-23 20:12:24
The 3-argument output is available in older versions as well; I'm not sure how far back it goes.In my experience, the raw output is superior to using the [num,txt] outputs because MATLAB "helpfully" discards non-numeric header rows and/or columns around the edges of the num output.
Arthur Ward
2010-06-23 22:29:01
By the "in matlab 2010" I meant using `~` as a way of specifying an output but not actually naming any variables ... in the other example `[num, txt, raw] = xlsread('data.xlsx',1, 'D2:D4')` you will have an extra `num` and `txt` variable in your workspace.
JudoWill
2010-06-24 02:13:10