How to create the additional excel sheets using cold fusion export?

General Web Dev
1

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

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.