Skip to main content
adamaas
Known Participant
November 26, 2012
Question

How to display graph in excel after an export ?

  • November 26, 2012
  • 1 reply
  • 874 views

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.

This topic has been closed for replies.

1 reply

Inspiring
November 26, 2012

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

What format is your chart?