app.UITable.Data assignment problem

2 次查看（过去 30 天）
Sharmin Sultana Sheuly
评论： Sharmin Sultana Sheuly 2020-5-6
hello,
I am having problem in assigning to app.UITable.Data.
My code is below
[Whole_data,txt,raw]=xlsread('shim_result.xlsx');
app.UITable.Data(row_nummber,2)=raw(row_nummber,2);
here, raw(row_nummber,2) is date time.
it shows the error message"Conversion to double from cell is not possible."
If I convert the date time to double than it does not appears in the table in the normal year- month-day format.
I cant change the whole table to date time as there are other numeric values. The table that I am developing in app designer has the following columns
Pallet number | date time | adjustmnet| shim dimension
Please help me.
Kind regards
Sharmin
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2020-5-6
@Geoff, the problem is the other way. It's raw(row_nummber,2) that is the cell array and Data the double array.
Sharmin Sultana Sheuly
Sharmin Sultana Sheuly 2020-5-6
Hello,
Thanks for your help. I have solved the problem.
regards
Sharmin

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2020-5-6
编辑：Guillaume 2020-5-6
raw(row_nummber,2) is a cell array (made of just one cell),
raw{row_number, 2} is the content of that cell. As long as that content is a scalar double, then:
app.UITable.Data(row_nummber,2)=raw{row_nummber,2}; %note the use of {} to get the content of the cell
should work (assuming Data is a double matrix).
edit: see Access data in a cell array to understand the difference between {} and () when indexing cell arrays.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by