How to change value of specific uitable cell on MATLAB GUI?

Good day! I am working on MATLAB GUI and I would like to ask how can I add change the numeric value (by adding/subtracting value) on a specific cell of uitable? Given that the entries shown on the uitable are called from an excel file, how can I change the value on a specific cell using a push button?

For an example:

The data is transferred from the excel file to uitable:

cell 1 value = '4', cell 2 value = '5'.

1st condition:

When push button 1 is pressed, it subtracts 1 from the cell values:

cell 1 value = '3', cell 2 value = '4'.

2nd condition:

When push button 2 is pressed, it adds 1 to the cell values:

cell 1 value = '5', cell 2 value = '6'.

Thank you so much.

Answer 1

[Walter Roberson]

If you read in the files from the file as text, use str2double() to convert them to numeric form. Set the Data property of the uitable to be the numeric values. Suppose that table is handles.uitable1 then set(handles.uitable1, 'Data', TheValues)

If all of the cells of the uitable are to be numeric, then TheValues can be a numeric array instead of a cell array that includes scalar numeric values.

If you were able to use numeric arrays for the uitable, then when the first button is pushed,

data = get(handles.uitable1, 'Data');
data = data - 1;
set(handles.uitable1, 'Data', data);

otherwise

data = get(handles.uitable1, 'Data');
for K = 1 : 2
  data{K} = data{K} - 1;
end
set(handles.uitable1, 'Data', data);

[Mary Requilman]

Thank you for answering, Walter Roberson. I tried your codes and kind of changed it a bit and they actually worked just as fine. These are what I used:

 %--- subtraction
function c1m_Callback(hObject, eventdata, handles)
data = get(handles.uitable1, 'Data');
data = data - 1;
set(handles.uitable1, 'Data', data);

 %--- addition
function c1a_Callback(hObject, eventdata, handles)
data = get(handles.uitable1, 'Data');
data = data + 1;
set(handles.uitable1, 'Data', data);

But the problem with the codes is that when I pressed either of the buttons, the entire data on the table gets affected by the arithmetic operation. What I would like to implement is that buttons c1m and c1a can only change the values assigned to cell A1 of the uitable1. Can you help me again on this one? Thank you so much.

[Walter Roberson]

data{1,1} = data{1,1} - 1;

and correspondingly

data{1,1} = data{1,1} + 1;

[Mary Requilman]

Thank you for your response, Walter. But I encountered an error.

??? Cell contents reference from a
non-cell array object.
Error in ==> TabPanel>c1a_Callback at 782
data{1,1} = data{1,1} + 1;
Error in ==> gui_mainfcn at 96
      feval(varargin{:});
Error in ==> TabPanel at 42
  gui_mainfcn(gui_State,
  varargin{:});
Error in ==>
@(hObject,eventdata)TabPanel('c1a_Callback',hObject,eventdata,guidata(hObject))

The same happened with:

data{1,1} = data{1,1} - 1;

[Walter Roberson]

You must be using numeric Data property instead of cell. Use

data(1,1) = data(1,1) + 1;

[Buddhini Angelika]

Is there a way to make alterations to the contents of the cells of uitable from the interface, by manually typing on the cells?

[Walter Roberson]

Buddhini Angelika: Yes, if you set the ColumnEditable property to allow editing the content.