Announcement

Collapse
No announcement yet.

[script] Xlgraph.vbs - Generate graphs in Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    [script] Xlgraph.vbs - Generate graphs in Excel

    The script reads values from an Access database, calls excel to create a graph of the data and then export the graph as a jpg or gif file.

    Requirements:
    -Homeseer 1.5.2 bld 39 or higher (for the ini-file functions in HS)
    -Excel must be installed on the Homeseer machine

    Installation:
    -copy the file Xlgraph.vbs into homeseer script directory
    -copy the file Xlgrpah.ini into the homeseer config directory
    -edit XLGraph.ini to customize to your system:

    -included a config utility xlgraph_config.asp
    Please BACKUP your ini file before using.
    put the files xlgraph_config.asp and xlgraph_docs.htm in the html directory and display
    using your browser. It will read xlgraph.ini file and allow you to display/edit
    the default and a user selected ini section at the same time. The keys link to the
    doc file. Some of the links don't work as I still need to update the doc file.

    -added the following:
    lngChartTitleFontColor, bChartTitleFontBold, bChartTitleFontItalic, intChartTitleFontUnderline
    lngXaxisTitleFontColor, bXaxisTitleFontBold bXaxisTitleFontItalic intXaxisTitleFontUnderline
    lngYaxisTitleFontColor bYaxisTitleFontBold bYaxisTitleFontItalic intYaxisTitleFontUnderline
    lngXaxisLabelFontColor bXaxisLabelFontBold bXaxisLabelFontItalic intXaxisLabelFontUnderline
    lngYaxisLabelFontColor bYaxisLabelFontBold bYaxisLabelFontItalic intYaxisFontUnderline
    lngLegendFontColor bLegendFontBold bLegendFontItalic intLegendFontUnderline
    Attached Files
    Last edited by jsteed; March 15, 2005, 09:41 PM. Reason: updated script
Working...
X