ExcelPlotter.Excel Class Reference

Public Member Functions
def	__init__ (self)
def	plot (self, h)

Public Attributes
	ex
	wb
	ws
	ch
	ser

Detailed Description

Definition at line 4 of file ExcelPlotter.py.

Constructor & Destructor Documentation

def ExcelPlotter.Excel.__init__

(

self

)

Definition at line 5 of file ExcelPlotter.py.

    def __init__(self):
        self.ex = win32com.client.Dispatch('Excel.Application')
        self.wb = self.ex.Workbooks.Add()
        self.ws = self.wb.WorkSheets.Add()
        self.ws.Name = 'HistoData'
        self.ch = self.wb.Charts.Add()
        self.ch.Name = 'HistoPlot'

Member Function Documentation

def ExcelPlotter.Excel.plot	(		self,
			h
	)

Definition at line 12 of file ExcelPlotter.py.

    def plot(self, h):
        self.ex.Visible = 0
        heights = h.heights()
        nbin = len(heights)
        xmin, xmax = h.edges()
        for i in range(nbin) :
            self.ws.Cells(i+1,1).value = heights[i]
            self.ws.Cells(i+1,2).value = xmin + i*(xmax-xmin)/nbin 
        self.ch.SetSourceData(self.ws.Range(self.ws.Cells(1,1), self.ws.Cells(nbin+1,1)))
        self.ch.HasTitle = 1
        self.ch.ChartTitle.Text = h.title()
        self.ser = self.ch.SeriesCollection(1)
        self.ser.XValues = self.ws.Range(self.ws.Cells(1,2), self.ws.Cells(nbin+1,2))
        self.ex.Visible = 1

Member Data Documentation

ExcelPlotter.Excel.ch

Definition at line 10 of file ExcelPlotter.py.

ExcelPlotter.Excel.ex

Definition at line 6 of file ExcelPlotter.py.

ExcelPlotter.Excel.ser

Definition at line 23 of file ExcelPlotter.py.

ExcelPlotter.Excel.wb

Definition at line 7 of file ExcelPlotter.py.

ExcelPlotter.Excel.ws

Definition at line 8 of file ExcelPlotter.py.

---

The documentation for this class was generated from the following file:

• GaudiPython/home/ExcelPlotter.py