Hi

I want to export an graph to excel sheet........can anybody say how to do it

I found a nice little tutorial on how to export your data from the database to an excel spreadsheet: http://www.phpfreaks.com/tutorials/114/0.php

To create the graph in excel, you could write a macro which could be run which would display the graph.

If you want to graph the data from php and display it for the web, then it would be best to use the GD graphics library and use the data in your MySQL DB (which should be exactly the same as the data in the mysql spreadsheet).

Here's a link to a tutorial on how to do just that: http://www.phpbuilder.com/columns/allan20000830.php3?page=1

Hope this helps.

ITA

How do I embed a macro?



: I found a nice little tutorial on how to export your data from the
: database to an excel spreadsheet:
: http://www.phpfreaks.com/tutorials/114/0.php
:
: To create the graph in excel, you could write a macro which could be
: run which would display the graph.
:
: If you want to graph the data from php and display it for the web,
: then it would be best to use the GD graphics library and use the
: data in your MySQL DB (which should be exactly the same as the data
: in the mysql spreadsheet).
:
: Here's a link to a tutorial on how to do just that:
: http://www.phpbuilder.com/columns/allan20000830.php3?page=1
:
: Hope this helps.
:
: ITA
:
:

About exporting data to Excel, I want to introduce you an article on Codeproject.
http://www.codeproject.com/KB/cs/Excel_PDF_Word_ExportWiz.aspx.
I think that it will be very useful for you!