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

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
<cfheader name="content-disposition" value="inline;filename=AccessToExcelDump.xls">
<cfcontent type="application/msexcel">
<table border="1">
</tr><cfoutput query="qryAccessData">

this is my piece of code to create excel file But i need to create two more additional sheets similarly like to do this.Please help me on this.

thanks and regards,

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