excel charts ?

[aashishn86]

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...

[aashishn86]

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

[jess]

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.

[aashishn86]

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....

[aashishn86]

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...

[ivy3]

I think that this article may be helpful for you!
http://www.dotnetspark.com/kb/3716-fast-export-data-from-database-to-excel.aspx