How to display graph in excel after an export ?

[adamaas]

Hello,

Please forgive me if am not in the right discussion.

I have a problem with an export of graph to excel, can anybody help me please ?

Actually when I export my request to a page, it displays well with the graph and when I put my header excel back, it does the export but the graphs are nowhere to be seen.

Here is a sample of the code I've used:

<cfheader name="content-disposition" value="attachment; filename=ExportGraph_#DateFormat(now(), 'yyyy-mm-dd')#.xls" charset="UTF-8">
<cfcontent type="application/vnd.ms-excel">
<cfoutput>
                              <!-- Affichage des graphes (2 graphes par ligne) -->
            <h2>Graphes</h2>
                              <cfset i = 0>
                              <table cellspacing="10px">
                      <cfloop query="GraphesList">
                                                  <cfif (i mod 2) EQ 0><tr></cfif>
                                                            <td><cf_graphe_v2 graph_id="#Id#"  range="#url.range#" name="#Name#"></td>
                                                  <cfif (i mod 2) EQ 1></tr></cfif>
                                                  <cfset i = i+1>
                                        </cfloop>
           </table>
</cfoutput>

Can anybody help please ?

Thanks in advance.

[Dan_Bracuk]

Don't use html tags to produce your excel content.  Use cfspreadsheet instead. 

What format is your chart?