Info

This question is closed. Reopen it to edit or answer.

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

1 view (last 30 days)
Supriya Gain
Supriya Gain on 9 Aug 2020
Closed: MATLAB Answer Bot on 20 Aug 2021
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?

Answers (1)

Abdolkarim Mohammadi
Abdolkarim Mohammadi on 9 Aug 2020
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');

Community Treasure Hunt

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

Start Hunting!