Error importing excel table into app designer table
显示 更早的评论
Hi,
I am a beginner to MATLAB and making an application using App Designer. I have been working and haven't been able to find an answer online, but I am trying to get a button in my app so that; when the button is clicked, I can choose a excel(csv) file to display onto the UI table once chosen.
However, I am receiving the following error; Error setting property 'Data' of class 'Table': Values within a cell array must be numeric, logical, or char
Is there a problem with my code or is this an issue with my data set? My data set contains a mixture of integers, strings, date and time.
Below is my code for the callback on the button;
[filename, pathname] = uigetfile({'*.csv'},'File Selector');
fullpath = strcat(pathname,filename);
x = readtable(fullpath);
app.UITable.Data = table2cell(x);
Many Thanks for your help
4 个评论
Kojiro Saito
2018-10-2
I couldn't reproduce this with my CSV data. Could you provide your sample (extracted) CSV?
Tamim Hussain
2018-10-2
Kojiro Saito
2018-10-3
Is it possible to provide your sample data? Because I've created a dummy csv file as the attached and it works without an error with your above codes. I think it's difficult to investigate why the error occurs without your sample data.
Tamim Hussain
2018-10-3
编辑：Tamim Hussain
2018-10-3
采纳的回答
Kojiro Saito
2018-10-5
In case of your Journals.csv, you don't need to use table2cell. Just setting a table as a value works.
x = readtable(fullpath);
app.UITable.Data = x;
% Change column name from imported data
app.UITable.ColumnName = x.Properties.VariableNames;
Result in App Designer.
4 个评论
Tamim Hussain
2018-10-7
Micaela Boursier
2019-8-6
Is there a way to pull a specific cell value into app designer,
for example, a user inputs the number that appears in the first column, and based on that value the remaining values in that row would be directed to designated text value boxes in app designer? This way specific values could be changed, for faster editing.
KRISHNA PATIL
2021-10-13
Thank you Kojiro Saito today you made my day as I was looking for someting and got the exact what i want. can you please help me for standaloon application further more. waiting for your reply.
Kojiro Saito
2021-10-14
Could you post your question in MATLAB Answers?
更多回答（1 个）
sarthak rawat
2018-12-21
0 个投票
error:"Struct contents reference from a non-struct array object."
comes in line "app.UITable.ColumnName = x.Properties.VariableNames"
please help!!
2 个评论
Kojiro Saito
2018-12-25
Could you give more detail information (codes or mlapp and csv data) to investigate why the error occurs, please?
Rubén García García
2020-4-18
function seleccionararchivoButtonPushed(app, event)
global archivo
[ filname, pathname ] = uigetfile({'*.xlsx'},'File Selector');
fullpathname = strcat(pathname,filname);
archivo = xlsread(fullpathname);
app.Label.Text = filname;
app.UITable.ColumnName = [{'Gb','Ta','Ta','Ts','Flujo'}];
app.UITable.Data = array2table(archivo);
类别
在 帮助中心 和 File Exchange 中查找有关 Develop Apps Using App Designer 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
