<!-- An example that shows how to generate a simple Excel report with one single line of code using cf_xls_quickreport.
		 -->

<cfquery name="getStudents" datasource="xlsadaptersampledb" dbtype="ODBC">
	SELECT * FROM Students ORDER BY LastName;
</cfquery>

<!-- 
	cf_xls_quickreport will creat a simple dump of a query to an Excel Workbook and display it. 
		Parameters:
			SaveAsName= name of the workbook returned.
			query= the query to output to the workbook.
			HeaderRow= Yes or No (if yes, the first row of the Excel sheet will become the query column names.
-->
<cf_xls_quickreport SaveAsName="quick1.xls" query="#getStudents#" headerrow="Yes" />