ASP to Excel

[Gatorajc]

Can anyone tell me if is possible to create a graph in excel from that is dynamically created from data an ASP page? I have found information on how to connect to an excel spread sheet but not how that data can generate a graph without actually having to go in and create the graph. I want to be able to open the spread sheet and see the graph. If this can be done can you point me to the site I can see it how to do it.

Thanks in advance
AJ
I would lose my head if it wasn't attached.

 

[tklear]

I have just done this so I can lead you to this reference (look under heading of "turn the tables&quot:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwebteam/html/webteam07032000.asp

Basically, you just need to use the following command:

Response.ContentType = "application/vnd.ms-excel"

Then create your table in html beneath that. Anything after the above command is fed into excel which opens up in the browser (along with the Excel menu containing Data sorting menu options). When you create the table, each <tr> starts a row in the spreadsheet and each <td> designates a cell.

The only problem I've run into is when I moved it to an SSL environment to test it doesn't work and I'm trying to see if there's a work-around or different syntax to adjust for ssl. If you find anything please post to this thread. Thanks!