Spreadsheet in Homeseer - Ideas on how?

[simonog]

I have a termperature sensor on hs and want to add a link to my hs pages which will allow a web visitor to see a graph of the temperature.

I have written a script to smooth the readings and create a file which Excel can use to make a neat chart.

Anyone a really neat way of making a link on the hs homepage go to a page which displays the Excel chart?

[jsteed]

If your script already creates the chart then the simplest is to export the chart as JPG file which is then displayed on the webpage. You might be able to use one of the following snippets to export the chart as either a JPG or GIF file

if you're working with the excel object from a script:
wb.Activechart.Export strExportGraph, "JPG"
where wb is the object and strExportGraph is the filename

This works as a macro in excel itself:
Sub Create_JPG()
Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(1).Chart
mychart.Export FileName:="e:\temp\Mychart.jpg", FilterName:="JPG", Interactive:="True"
End Sub

you might want to take a look at Xlgraph in the script library- it was written to collect the data, generate charts, and export them. It allows customizing the settings of the chart.
jim