Info

此问题已关闭。 请重新打开它进行编辑或回答。

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

2 次查看（过去 30 天）
Supriya Gain
Supriya Gain 2020-8-9
关闭： 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?

此问题已关闭。

回答（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');

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by