Effacer les filtres
Effacer les filtres

app.UITable.Data assignment problem

2 vues (au cours des 30 derniers jours)
Sharmin Sultana Sheuly
Sharmin Sultana Sheuly le 5 Mai 2020
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 commentaires
Guillaume
Guillaume le 6 Mai 2020
@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 le 6 Mai 2020
Hello,
Thanks for your help. I have solved the problem.
regards
Sharmin

Connectez-vous pour commenter.

Réponse acceptée

Guillaume
Guillaume le 6 Mai 2020
Modifié(e) : Guillaume le 6 Mai 2020
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.

Plus de réponses (0)

Catégories

En savoir plus sur Data Type Conversion dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by