Prev: Redirecting pages
Next: <cfform> and Fireworks Menu - syntax error
From: ulin9je on 8 Jun 2006 16:22
Is there a way to embed math formula when export data to Excel file using <cfcontent>?

Thanks!!
From: Wizard-of-Vos on 9 Jun 2006 18:25
The simplest way I can think of is by using a HTML and placing the
formula in the TD:

------------------------------------------------------------------
<cfheader name="Content-Disposition" value="inline;
filename=demosheet_pablo.xls">
<cfcontent type="application/msexcel" >


<table border="1" cellspacing="0">
<thead>
<tr>
<th>HEADER</th>
</tr>
</thead>
<tbody>

<tr>
<td>=1+1</td>
</tr>
</tbody>
</table>

From: cecropin on 13 Jun 2006 11:37
Depending on what version of Excel you have, pushing the content out as XML and
having Excel read it is probably your best bet, especially since you want to
embed a formula in the spreadsheet. You should be able to google Excel and XML
for more detailed tutorials and examples.

-Tim

From: ulin9je on 20 Jun 2006 16:40
Thank you, Tim!
I will give it try!
 | 
Pages: 1
Prev: Redirecting pages
Next: <cfform> and Fireworks Menu - syntax error