How can I get the sum of rows and columns of a table and add them to the table?

I want to get the totals of each row and column from a table with values inserted by a user

This is my script so far:

row = input('Enter number of rows: ');
col = input('Enter number of columns: ');
for i = 1:row
  for j = 1:col
    str = ['Enter element in row ' num2str(i) ', col ' num2str(j) ': '];
    A(i,j) = input(str);
  end
end
A;

See the images for how I want it to look compared to how it looks now

Answer 1

[KL]

After you get the row and col values from the user, pre-allocate it by,

 A = zeros(row+1,col+1);

I say "+1" because that'S where I want to store the sum. Now get the values from user as in the for loop, then to caluclate sum of all rows,

 A(end,1:col) = sum(A(1:row,1:col),1); %last element will be 0

to sum all columns

 A(1:row,end) = sum(A(1:row,1:col),2); %again, last element will be 0

final result will be like, (for a 3x3 input)

    0.8673    0.8289    0.2804    1.9766
    0.7212    0.7730    0.7949    2.2891
    0.1438    0.3716    0.2151    0.7304
    1.7322    1.9735    1.2904         0

[WilliamHSs]

What if I want where the 0 is to contain the total of all rows and columns?

[KL]

 A(end,end) = sum(sum(A(1:row,1:col)))

[KL]

You missed the pre-allocation part, the very first step of my answer.

row = input('Enter number of rows: ');
col = input('Enter number of columns: ');
A = zeros(row+1,col+1);
for i = 1:row
  for j = 1:col
    str = ['Enter element in row ' num2str(i) ', col ' num2str(j) ': '];
    A(i,j) = input(str);
  end
end
A;
A(end,1:col) = sum(A(1:row,1:col),1);
A(1:row,end) = sum(A(1:row,1:col),2);
A(end,end) = sum(sum(A));

and after seeing your table creation i'm confused. If the user could input row and col values, how's that you want to create a table with yes, no as column names? what if the user says row=5 and col=7?

[Image Analyst]

That code still doesn't produce a uitable with any red and black borders, like you wanted and showed in the image you posted.

[KL]

@Stavro1095: Yes, that's true. This simply creates a matrix in the workspace. If you want to store this matrix in an excel file with custom formatting, you'd have to use ActiveX like IA has suggested.

Answer 2

[Image Analyst]

Not sure you can do that in MATLAB unless you try some undocumented calls to java. See http://undocumentedmatlab.com/

If you want to make it look like that in an Excel workbook, you can use ActiveX (Windows only) to have MATLAB tell Excel to format the cell shading and borders in any style you want. A generic ActiveX demo is attached.