app.UITable.Data assignment problem

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

[Geoff Hayes]

Sharmin - what happens if you use braces instead of brackets in the assignment?

app.UITable.Data{row_nummber,2}=raw(row_nummber,2);

[Guillaume]

@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]

Hello,

Thanks for your help. I have solved the problem.

regards

Sharmin

Answer 1

[Guillaume]

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.