Import data from Excel to Matlab GUI

2020 4 22
1 个回答
回答已采纳
更新时间：2020 4 22
2 次查看（30 天）

0 个投票

Hi everyone!
Hope all is well!
I have a slight problem with uploading my excel file that includes TEXT and NUMBER to Matlab GUI (Uitable).
On my excel file i had TWO columns, 1st column in text format and the 2nd column in number format.
As shown below it only displays the second column NOT the first column.
I typed this on the command window on Matlab GUI:
>> data = xlsread('height.xlsx');
>> data
data =
55
83
79
40
58

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

 采纳的回答

Adam Danz
Adam Danz 2020-4-22

0 个投票

xlsread returns the numeric data in a matrix. The first column of your data are not numeric.
Use readtable() instead.

6 个评论
显示 4更早的评论 隐藏 4更早的评论

Miss B
Miss B 2020-4-22
编辑：Miss B 2020-4-22
Thank you.
I tried that but, now when I try load the data from the workplace, nothing appears on the uitable in GUI.
But when i go back to using xlsread on command window - the data loads successfully from workplace and appears on the table.
Adam Danz
Adam Danz 2020-4-22
That may be due to an error in reading in the data or it could be due to an error in assigning the values to the uitable. Have you checked that the data is read-in correctly? If that's the error, what's the output of readtable() and what inputs are you using? If the problem is with assigning the data to a uitable, that's a different problem than what's asked in the quesiton.
Miss B
Miss B 2020-4-22
This is the output for readtable() on COMMAND WINDOW.
data =
5×2 table
Var1 Var2
__________ ____
{'weight'} 56
{'food'} 47
{'height'} 89
'I have a slight problem with uploading my excel file that includes TEXT and NUMBER to Matlab GUI (Uitable).'
I made it clear here ^ that itll display on a Uitable on Matlab GUI.
Adam Danz
Adam Danz 2020-4-22
You can convert the table to a cell array before loading it to the uitable,
C = table2cell(T)
Miss B
Miss B 2020-4-22
Thank you very much yet again!
Your help and support is immensely appreciated.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 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