I have a excel file which contains both number and txt, I wanna assign whole values in this excel file to the listbox

for example,

first column of the excel file includes only txt second column of the excel file includes only num third column of the excel file includes only num

the excel file's size nx3

I wanna assign these nx3 into the list box with both txt and num.

Answer 1

[Yao Li]

1. Import data to Matlab by implementing xlsread()
2. Create a cell variable and assign all the n*3 data to the cell variable

[sermet]

I see, but I cannot arrange these values by column and row into the listbox.

[Yao Li]

Why no use Table in GUI in place of listbox?

[Yao Li]

Try

set(handles.listbox1,'String',{'1 2','3 4'});

I think you can find what you want from this example.