Am trying to export an ASP script generated report, which includes a HTML graph (actually a series of HTML generated images), to Excel. I can export the report fine, but can not export the graph.
---------

Response.Buffer = true
Response.ContentType = "application/msexcel"
Response.AddHeader "content-disposition", "attachment; filename=report3.xls"
---------
Any suggestion?
thx alot

Jorge

__________________
Jorge

<img src="blank.gif" style="background-color:#ff0000;" width="15" height="<%=h1%>" border="1"> This generate one bar (in red) of a particular graph.

Jorge

Alternatively, <table> tag can be used: <table bgcolor="#ff0000" width="15" height="<%=h1%>" border=0 cellpadding=0 cellspacing=0><tr><td></td></tr></table>

Jorge

Jorge,

I had the same problem. A HTML graph can't export to Excel.
Did you find a solution?

Thanks,
Jim

Have you thought of rendering the graph as an image then exporting the image, this is how I have done it. We have built a library file that does this; I believe there are other ones out there.

Basically the procedure we use is to pass variables inside the image tag calling the page that initiates the object:

<IMG SRC="barIncidentOrGraph2.asp?width=700&height=410& startItem=<%= getInfoArray(0,topElement) %>&startDate=<%= start %>&finishDate=<%= finish %> " width="700" height="410">

Then on barIncidentOrGraph2.asp we initiate the object, query the dataStore based on the values being passed in the image tag and then pass a two dimensional array into it. Using:

response.Binarywrite(chartObj.GetImage)

To build the graph it’s self.


Wind is your friend
Matt

I did manage to export a graph to Excel working on my local machine that has a web server installed. However when I deployed to a testing web server, it was not working. I believed it was a configuration issue on the web server, but I don't what it was. Anybody has ideas?

Thanks,
Jim

I believe Excell need to be installed on the web server just like it is on your local machine.

Wind is your friend
Matt

Hi,
I am in a similar situation. Except that I am using a jsp. Did rendering the different bar images in html and exporting them into excel work?

I will also look at the other suggestion of rendering a image and then trying that one out.

Thanks

Sorry for the late reply (been away). Will review above - of note we were considering posibily writting an applet


Jorge