Creating Summary page in Excel

4 次查看（过去 30 天）
Russell
Russell 2014-5-30
回答： Image Analyst 2014-5-30
I am trying to create a sheet at the end of my Excel workbook that will essentially be a summary of all date in the workbook.
I have a Matlab script that takes raw data and converts it into a series of N worksheets that represent the n number of files. The script also produces charts.
I just need to take all of the sheets and average them out as well with the script. Please help me start this.
Thanks :)

请先登录，再回答此问题。

回答（1 个）

Image Analyst
Image Analyst 2014-5-30
You already have the data, since you wrote it out to the individual worksheets. So just do the averaging in MATLAB like you'd expect, and write out another worksheet just like you did all the others. I guess I'm not sure why you don't know how to do this already since you obviously already know how to program in MATLAB and possibly ActiveX, and you already know how to create workbooks and worksheets.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by