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

Question

Supriya Gain 2020-8-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/577330-average-from-a-excel-sheet-and-store-it-to-a-different-excel-sheet

关闭： MATLAB Answer Bot 2021-8-20

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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

此问题已关闭。

Answer 1

Abdolkarim Mohammadi 2020-8-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/577330-average-from-a-excel-sheet-and-store-it-to-a-different-excel-sheet#answer_477277

在 MATLAB Online 中打开

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');