CF_XLS_QuickReport

Description

Exports a ColdFusion query to an excel workbook. The workbook is created with no formating. To use formatting look at CF_XLS_Workbook.

Syntax

<CF_XLS_QuickReport 
   HeaderRow = "yes" or "no"
   Query = "Variable name of query"
   SaveAsName = "Client Filename"/>

Attributes

Attribute Req/Opt Default Description
HeaderRow Opt No Determines wheather the first row of the workbook contains the names of the columns from the query.
  • yes: the first row contains the columns of the query.
  • no: the first row contains the first row of data from the query.
Query Req   A variable containing a ColdFusion query.
SaveAsName Opt QuickReport.xls Filename of the workbook to display to the browser.

Example

See the examples page.