This paper presents a discussion on how to take full advantage of Excel’s report function and OLE automation to make reports for the monitoring & analyzing system in power plant.It introduces a design of complicated formats using Excel application and describes briefly the notion of OLE automation.Finally it shows how to use Visual C++ to connect Excel application by using OLE Automation and how to input data into the range of Excel wordsheet.