Set listbox with excel content --Attempt to reference field of non-structure array

1 Ansicht (letzte 30 Tage)
I have a GUI in which a want to set the content of an Excel file in a listbox, the code used is:
[ndata, text, alldata] = xlsread(filename);
set(handles.list_register,'String',cell2str(text));
The Excel file contains only one column with a string in each cell. Once the xls file is read the variable text is a cell type. When I compiled I got:
Attempt to reference field of non-structure array.
Error in Register>list_register_CreateFcn (line 100)
set(handles.list_register,'String',fields(struct(text)));
Thanks in advance for your help,

Antworten (2)

Azzi Abdelmalek
Azzi Abdelmalek am 15 Okt. 2013
Bearbeitet: Azzi Abdelmalek am 15 Okt. 2013
cell2str is not a valid Matlab function, it's cellstr and the variable text is already a cell array
  4 Kommentare
Manuel
Manuel am 15 Okt. 2013
Sorry again I copied an old error, the erros is:
Attempt to reference field of non-structure array.
Error in Register>list_register_CreateFcn (line 100)
set(handles.list_register,'String',text);

Melden Sie sich an, um zu kommentieren.


sixwwwwww
sixwwwwww am 15 Okt. 2013
Dear Manual, I assume that "text" just has one cell then you do like this:
[ndata, text, alldata] = xlsread(filename);
set(handles.list_register,'String',text{:});
I hope it helps
  6 Kommentare
Azzi Abdelmalek
Azzi Abdelmalek am 16 Okt. 2013
Why your code is in function list_register_CreateFcn ? It should be in any callback
Manuel
Manuel am 16 Okt. 2013
Bearbeitet: Manuel am 17 Okt. 2013
There is a button which opens a new GUI called Register, and when this Register is called then the listbox inside this Register needs to be created with text as content.
@Azzi Abdelmalek if you Need more data let me know.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Interactive Control and Callbacks finden Sie in Help Center und File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by