How to create chart from asp to excel

[19511950]

Hi,

I get information from SQL Server into asp and open it in Excel.
<%'--This code open file in excel---
Response.Buffer=TRUE
Response.ContentType = "application/vnd.ms-excel"
%>
<table border=1>
<tr>
<td>Name</td>
<td>Count</td>
</tr>
<%do while not RS.EOF%>
<tr>
<td><%=RS("NAME")%></td>
<td><%=RS("CNT")%></td>
</tr>
<%RS.movenext
loop%>
</table>

When Excel file is open I press F11 and it converted to the chart.

I need the code that will open chart from asp into Excel.


Thanks,

Mark

 

[NoCoolHandle]

So what you want to do is (from an asp page) intercept an application level keypress event, replace the default behavour with a custom action that allows InterNet explorer to open an outside program, populate it with data and display it to the user?

If so... I don't think so.. (security/virus)

However you might be able to purchase code that builds a graph from data you are displaying in your webpage.

I think there was a product called dynacube or something like that from datadynamics that might do what you want, or my might want to consider building activeX controls or directly downloading an xls file into the browser.

HTH

Rob