Creating Summary page in Excel

3 visualizaciones (últimos 30 días)
Russell
Russell el 30 de Mayo de 2014
Respondida: Image Analyst el 30 de Mayo de 2014
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 :)

Respuestas (1)

Image Analyst
Image Analyst el 30 de Mayo de 2014
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.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by