I wish to create a excel file with two or three additional sheets using cold fusion and sql query?
<cfquery datasource="#session.DataSource#" name="qryAccessData">
select top 10 contactid,firstname,lastname from tblpeople
</cfquery>
<cfheader name="content-disposition" value="inline;filename=AccessToExcelDump.xls">
<cfcontent type="application/msexcel">
<table border="1">
<tr>
<th>Field1</th>
<th>Field2</th>
<th>FieldN</th>
</tr><cfoutput query="qryAccessData">
<tr>
<td>#qryAccessData.contactid#</td>
<td>#qryAccessData.firstname#</td>
<td>#qryAccessData.lastname#</td>
</tr></cfoutput>
</table>
this is my piece of code to create excel file But i need to create two more additional sheets similarly like this.how to do this.Please help me on this.
thanks and regards,
S.boopathi