is there a way by which i can generate a excel report in asp and create a chart corresponding to it using asp as well...

that is i want to generate a chart dynamically when i export the data to an excel sheet using asp, in the same sheet .

is there a way by which i can generate a excel report in asp and create a chart corresponding to it using asp as well...

I know to create an excel sheet you do this:
(Put just below body line)

<%
Response.ContentType = "application/vnd.ms-excel"Response.AddHeader "Content-Disposition","inline;filename=myExcel.doc"
%>
Response.ContentType ="Application/vnd.ms-word"
Response.ContentType ="Application/vnd.ms-excel"
Response.ContentType ="Application/vnd.ms-powerpoint"

I'm not sure about the chart.

I know to create an excel sheet you do this:
(Put just below body line)

<%
Response.ContentType = "application/vnd.ms-excel"Response.AddHeader "Content-Disposition","inline;filename=myExcel.doc"
%>
Response.ContentType ="Application/vnd.ms-word"
Response.ContentType ="Application/vnd.ms-excel"
Response.ContentType ="Application/vnd.ms-powerpoint"

I'm not sure about the chart.

yups have already exported it...........need to generate the charts...
thank's anyways....

well maybe i can do that using macros...
is there a way i can include macros in the excel page i make
i don't have excel installed on my server...

This article has been dead for over six months. Start a new discussion instead.