I can't set the table etc between a <cfsavecontent
variable="pollingstats">, as it states that it's not a valid supported
variable type.
How would you set that table and looping from my example to a
variable? Put it in a structure or something?
You give me different ways of doing it, bit confused about what
belongs to what or what need to be in place together or not, can you
clarify?
Thanks
On Nov 3, 3:23 pm, "Tomek Kott" <[EMAIL PROTECTED]> wrote:
> Marco,
>
> Basically all you need is a table structure like your example. I actually
> found that your method wouldn't automatically pop up a "save as Excel"
> dialog box in all browsers. What I ended up doing was simply did a save
> content to a variable (<cfset ...>) and
>
> <cfheader name="Content-Disposition" value="attachment;
> filename=FormData.xls" />
> <cfcontent type="application/msexcel" variable="#myHTML#" />
>
> If you go this route though, be aware that for larger files where you might
> be running cfset often, you might want to switch to a Java class object:
>
> <cfset myHTML = createObject("java","java.lang.StringBuffer")>
>
> And then you would do
>
> <cfset myHTML.append("<tr>")>
>
> And your final cfcontent tag would look like:
>
> <cfcontent type="application/msexcel" variable="#ToBinary( ToBase64(
> totalHTML.Trim() ) )#" />
> To get it back to a normal string type. I found the above hint on some blog
> about coldfusion after I found that things were going very slowly for a 20
> row excel output. Doing things with the stringbuffer was much faster
> (although I don't know about the 'safety' of working with a more primitive,
> as I understand, class)
>
> Best,
>
> Tomek
>
> On Sun, Nov 2, 2008 at 9:34 PM, Marco van den Oever <
>
> [EMAIL PROTECTED]> wrote:
>
> > Hereby a simple method:
>
> > <cfcontent type="application/vnd.ms-excel">
> > <h2>Polling statistics: #stprops_pollingdata.question#</h2>
> > <table border="1" cellpadding="1" cellspacing="2">
> > <tr>
> > <th>Date / Time created</th>
> > <th>Question</th>
> > <cfloop index="i" from="1" to="#application['wsoFarcryPolling'
> > & pollingid]#">
> > <cfif stprops_pollingdata['answer' & i] GT 0>
> > <th>#stprops_pollingdata['answer' & i]#</th>
> > </cfif>
> > </cfloop>
> > <th>Total votes</th>
> > </tr>
> > <tr>
> > <td>#stprops_pollingdata.datetimecreated#</td>
> > <td>#stprops_pollingdata.question#</td>
> > <cfloop index="i" from="1" to="#application['wsoFarcryPolling'
> > & pollingid]#">
> > <cfif stprops_pollingdata['answer' & i] GT 0>
> > <td>#sums[i].recordcount#</td>
> > </cfif>
> > </cfloop>
> > <td>#answers_sum#</td>
> > </tr>
> > </table>
>
> > On Nov 3, 12:57 am, Marco van den Oever <[EMAIL PROTECTED]>
> > wrote:
> > > Is there a function to put db data in Excel???
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
