Error importing excel table into app designer table

Question

Tamim Hussain 2018-9-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421067-error-importing-excel-table-into-app-designer-table

评论： Kojiro Saito 2021-10-14

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 个评论
显示 2更早的评论隐藏 2更早的评论

Kojiro Saito 2018-10-3

SampleData.csv

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

Journals.csv

Hi, I have attached the data I am using, you will see there is a field called date posted and time posted (date and time data type in the csv file). Also I tried importing your sample data in App Designer and I still get the same error.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Kojiro Saito 2018-10-5

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/421067-error-importing-excel-table-into-app-designer-table#answer_339813

在 MATLAB Online 中打开

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 个评论
显示 2更早的评论隐藏 2更早的评论

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