Average from a excel sheet and store it to a different excel sheet.

I have a matrix file which consists of 2560 rows and 39 columns. In that file A3 and B3 consist of X and Y coordinate. C3 is time. Now i need to do average from D3 to G32 (it's like a 30X4 matrix). Now save the average value in a different excel sheet in this fashion like, in the new excel sheet A3 and B3 consist of that previous X and Y coordinate and C3 consist of the average value. Then i have to do average from H3:K32 and then save it under the same coordinate and beside the previous value, that means in D3.

Can anyone tell me how to do that?

Answer 1

[Abdolkarim Mohammadi]

You should first read the data from the excel file using readmatrix, then do any calculations like mean, and finally write to the excel file using writematrix. For example:

MatrixInMatlab = readmatrix ('data.xlsx', 'Sheet','MySheet1', 'DataRange','A1:B10');
MeanInMatlab = mean (MatrixInMatlab, 2);
writematrix (MeanInMatlab, 'Sheet','MySheet2', 'DataRange','C1');