MATLAB Answers

write in specific uitable cell

3 views (last 30 days)
naouras saleh
naouras saleh on 4 Nov 2019
Commented: naouras saleh on 4 Nov 2019
hello
i made an uitable and puch button with editable cell using the code below:
app.UITable.ColumnName={'position 1'; 'position 2 '; 'position 3 '; 'position 4 '};
t = app.UITable;
set(t,'data',ones(5,4))
set(t,'ColumnWidth',{100})
set(t,'ColumnEditable',logical([1 1 1 1]))
push button code:
function EntreButtonPushed(app, event)
t = app.UITable;
l= get(t, 'data');
xlswrite('sasa', l);
end
my questions are:
1- how can i add numeric numbers with (.) dot, (string data)?
2- the colume names of my table are not showen in the save file how can i add them? (ERROR: it is shownen that only accept numeric value and it is not array)
3-and finally, how can i add data to specific cells? like making some cells in uitable constant with particular value?
thanks

  0 Comments

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 4 Nov 2019
2:
if ~iscell(l)
l = num2cell(l);
end
l = [app.UiTable.ColumnName; l];
xlswrite('sasa', l);
3:
t.Data(Row, Column) = value;
However, making selected cells un-editable might be tricky. It is probably best to copy the "constant" values back in before writing the data to file.

  3 Comments

naouras saleh
naouras saleh on 4 Nov 2019
could you please re-write the full code for me including your code so i can learn because i'm new to the matlab, and i don't know where to put you code exactly and what should i delete :)
Walter Roberson
Walter Roberson on 4 Nov 2019
function EntreButtonPushed(app, event)
t = app.UITable;
l = get(t, 'data');
if ~iscell(l)
l = num2cell(l);
end
l = [app.UiTable.ColumnName; l];
xlswrite('sasa', l);
end
naouras saleh
naouras saleh on 4 Nov 2019
i have tested your code it shows error:
Unrecognized method, property, or field 'UiTable' for class 'app1wwwww'.
Error in app1wwwww/EntreButtonPushed (line 68)
l = [app.UiTable.ColumnName; l];
Error using matlab.ui.control.internal.controller.ComponentController/executeUserCallback (line 335)
Error while evaluating Button PrivateButtonPushedFcn.

Sign in to comment.

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!