JPowered.com

Active Graphs and Charts

Active Graphs and Charts

 

Reading Values from Spreadsheets

In this tutorial we show how to use the graphing package to plot data directly from spreadsheets in real time.

Configure the Graph

The first step is to configure the graph software to request the data from a server script. The server script will open and read the spreadsheet and pass the data to the graph. This is done with the parameter 'JpGraphPropertyFile'.

Here is the configuration used for this graph:-

Create the Data Script

For this example we have created the data script with PHP but the server side script can be written in any server side language e.g. Java, ASP, Python etc.

The script is fairly straight forward and performs the following steps:-

Whenever the spreadsheet is updated the graph will automatically update with the new values.

back to tutorial index