How to calculate data input by user in uitable and return in the same uitable

Hi.

I have created a uitable in GUI, 10rows x 3 columns (col A, col B, col C). col A is editable, and user needs to input integer in each row of col A. I want the calculated output to appear in col B & col C.

For example :

colA = A;
colB = A * 2;
colC = colA * colB;

How do I call the cell in each row/column of the same uitable? What is the type of data in uitable (String/Data)?

Please help! Many thanks.

Aiya.

Answer 1

[Image Analyst]

Just get the data property of the table

tableData = get(handleToTable, 'Data');

tableData will be a cell array with whatever was in the table. Since it's a cell array, the data class can vary. You can specify the class when you set up the table, or let MATLAB decide dynamically as the user types stuff in. To get a cell array that is one column of the entire cell array, just index as usual

columnA = tableData(:, 1);

[Walter Roberson]

And consider using cell2mat()

[Intan]

Hi, Image Analyst.

Thanks for your answer. I'm still having trouble calculating the value and putting it back to another column of the same table. I tried to put it in another table,but also fails. This is what I did in a pushbutton_Callback function :

data1 = get(handles.uitable1,'Data');

data2 = data1(:,1);

data3 = data2 * 2;

set(handles.uitable2,'Data',data3);

where uitable1 and uitable2 are 2 different tables with same number of rows & columns. The error came out as :

"Undefined function or method 'mtimes' for input arguments of type 'cell'"

How can I put the calculated values in uitable2, and also in another column of uitable1? The values to be calculated are entered by user into data1(:,1) of uitable1.

Many thanks.

[Intan]

Hi @Walter Roberson, can you explain how can I use cell2mat() for this function?

Many thanks.

[Walter Roberson]

data2 = cell2mat(data1(:,1));

data3 = data2 * 2;

newdata = [data1(:,1:2), num2cell(data3)];

set(handles.uitable2, 'Data', newdata);

[Intan]

Hi @Walter.

Thank you very much for the code. But error still occurs :

??? Error using ==> cat

CAT arguments dimensions are not consistent.

Error in ==> cell2mat at 89

m{n} = cat(1,c{:,n});

Error in ==> table>calc_Callback at 236

data2 = cell2mat(data1(:,1));

Why is this so?

[Walter Roberson]

Please execute this code and see if the results come out the same each time:

for K = 1 : size(data1,1)

t = data1{K,1};

class(t),size(t)

end

If they do come out the same, please let us know what they are.

[Intan]

Hi @Walter,

Yes, the result come out the same each time. If all rows in col 1 are filled in, result is :

ans =

char

ans =

1 1

If row is empty, result is :

ans =

char

ans =

1 0

[Walter Roberson]

"if the row is empty" is the crucial part. You did not mention anything about the possibility of rows being empty, and you did not indicate what you wanted to do in those cases.

You also did not mention that the rows were characters. Multiplying characters by 2 does have some meaning but it is unlikely to be the meaning you intend. If you need the entries to be converted to numbers, and need the outputs to be converted from number to characters then you should say so. After all, uitable entries can be numbers themselves (not the character representation of numbers) if the column has been set to numeric.

[Intan]

Hi @Walter. Sorry because I'm quite new with Matlab. But I didn't define the rows to be in characters, it was set by default. Yes, apparently I do want the data input from user in terms of numeric, and the value of that number to be multiplied by 2. If the row is empty, nothing should happen. The corresponding cell to be calculated using the empty rows should return 0 or blank. (does that make sense?). So how should I define the data in table as numeric? Can I use the previous code you gave using cell2mat() then?

Many thanks!

[monu]

but my code related to selecting column from the uitable doesn't run ......what to do ???????/

[Image Analyst]

How should we know? You just tacked this on to someone else's discussion that was 2 years old and didn't even give your code. How do you expect us to possibly say anything useful to you considering what you've told us??