MATLAB Answers

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

4 views (last 30 days)
Manuel
Manuel on 15 Oct 2013
Commented: Manuel on 16 Oct 2013
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,

Answers (2)

Azzi Abdelmalek
Azzi Abdelmalek on 15 Oct 2013
Edited: Azzi Abdelmalek on 15 Oct 2013
cell2str is not a valid Matlab function, it's cellstr and the variable text is already a cell array
  4 Comments

Sign in to comment.


sixwwwwww
sixwwwwww on 15 Oct 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 Comments
Manuel
Manuel on 16 Oct 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.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!