Set listbox with excel content --Attempt to reference field of non-structure array
古いコメントを表示
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,
回答 (2 件)
Azzi Abdelmalek
2013 年 10 月 15 日
編集済み: Azzi Abdelmalek
2013 年 10 月 15 日
0 投票
cell2str is not a valid Matlab function, it's cellstr and the variable text is already a cell array
4 件のコメント
Manuel
2013 年 10 月 15 日
Azzi Abdelmalek
2013 年 10 月 15 日
But the error message correspond to another line
set(handles.list_register,'String',fields(struct(text))
what struct(text) means?
Manuel
2013 年 10 月 15 日
Azzi Abdelmalek
2013 年 10 月 15 日
Post the entire code for this callback
sixwwwwww
2013 年 10 月 15 日
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 件のコメント
sixwwwwww
2013 年 10 月 15 日
Is your "text" contain any data? or is it empty? Also I agree with Azzi show us your code please
Azzi Abdelmalek
2013 年 10 月 15 日
If text is a cell array
set(handles.list_register,'String',text);
is correct
Azzi Abdelmalek
2013 年 10 月 16 日
Why your code is in function list_register_CreateFcn ? It should be in any callback
カテゴリ
ヘルプ センター および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!