Listbox problem in GUI

I have a GUI which has listbox in which I want to display numbers in first followed by strings or names The excel file has numbers and texts/names. How can I display both numbers and text in listbox using pushbutton callback Matlab is treating text as 'NaN' and I want to convert them to strings and display as text in listbox ...

Answer 1

[Walter Roberson]

You need to initialize the listbox as a cell array and use {} indexing with it. For example,

s = {3; 'hello'};
h = uicontrol('style','list','string', s);
...
hv = get(h,'Value');
hall = get(h,'String');
hcurrent = hall{hv}

[VBBV]

Ok, suppose if I am reading/loading the data using xlsread through pushbutton, extract the two columns of array, first contains numbers, second text/names ... and show them in listbox in same order... how can I do it

[Walter Roberson]

nent = size(RawData,1);
s = cell(nent, 1);
for K = 1 : nent
  s{K} = sprintf('%g %s', RawData{K,1}, RawData{K,2});
end
set(handles.listbox1, 'String, s)

[VBBV]

Ok, The array is of double type containing text and numbers, if I use cell or cellstr function ... it shows error ... conversion from double to cell or cellstr is not possible ...

[VBBV]

I used num2str() but the column extracted from array still shows .. 'NaN'

[VBBV]

it show 59 x 3 char array

[Walter Roberson]

It is not possible for a numeric array to contain both text and numbers.

If you are using xlsread() then the first output would be pure numeric with no text, and the second output would be pure text with no numeric, and the third output ("raw") would be a cell array in which individual entry could be either numeric or character vector. As that is the only way to get a mix of numeric and text with xlsread(), I assumed that you were working with that third output of xlsread()

I just corrected a typing mistake in the code I posted.