|
Hello, I’ve looked across the net and I can’t find out
if its possible to put a page break in an excel
document. I’ve included an
example script that I got from a Coldfusion Book that
I bought so that people know what I’m on about. I need to output data from a DB into excel and have it sorted
on separate pages. I can’t
find the command to do it. I’m
just a beginner at cfm and don’t really know
much XML or any other languages.
Some tips or advice would be good please. <!--- Filename: FilmsToExcelPrettier.cfm Author: Nate
Weiss (NMW) Purpose: Outputs film information for Microsoft
Excel ---> <!--- Retrieve
information about films ---> <CFQUERY DATASOURCE="ows"
NAME="GetFilms"> SELECT MovieTitle, AmountBudgeted FROM Films ORDER BY MovieTitle </CFQUERY> <!--- Set the
content-type so Excel is invoked ---> <CFCONTENT TYPE="application/msexcel"> <!--- Suggest
default filename for spreadsheet ---> <CFHEADER NAME="Content-Disposition"
VALUE="filename=FilmBudgets.xls"> <!--- Include
"XML Namespace" information to ---> <!--- allow using
Excel "extensions" to HTML ---> <html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head><title>Film
Budgets</title></head> <body> <style TYPE="text/css"> .rowHeads { color:white; background:blue; } .titleCol { width:400px; font-style:italic; font-family:verdana; } .priceCol { width:170px; font-family:verdana; color:red; mso-number-format:"\0022$\0022\#\,\#\#0\.00" }; </style> <!--- Output
ordinary HTML table, which will ---> <!--- be
displayed by Excel as a spreadsheet ---> <table> <!--- Top row ---> <tr>
<th class="rowHeads">Movie Title</th>
<th class="rowHeads">Amount Budgeted</th> </tr> <!--- Data rows ---> <CFOUTPUT
QUERY="GetFilms">
<tr> <td
class="titleCol">#MovieTitle#</td> <td
class="priceCol">#AmountBudgeted#</td>
</tr>
</CFOUTPUT> <!--- Last row, with "total" formula ---> <CFSET FirstPriceCell = "B2"> <CFSET LastPriceCell = "B" & GetFilms.RecordCount + 1> <CFSET TotalFormula
= "SUM(#FirstPriceCell#:#LastPriceCell#)">
<CFOUTPUT>
<tr> <td class="titleCol" style="font-weight:bold;background:yellow">Total:</td> <td class="priceCol" style="font-weight:bold;background:yellow" x:fmla="=#TotalFormula#"></td>
</tr>
</CFOUTPUT> </table> </body> </html> Thankyou David
Leney You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ |
