QUOTE(manjusha.pate @ 15 Oct, 2008 - 06:24 AM)
Hi,
I am new to ColdFusion. Can anyone suggest me the correct way to implement export functionality in ColdFusion application.
Below is the code -
<cfsetting enablecfoutputonly="Yes">
<cfquery name="queryData" datasource="#request.dsn#">
SELECT * from EMPLOYEE
</cfquery>
<cfcontent type="application/msexcel">
<cfheader name="Content-Disposition" value="filename=test.xls">
<cfoutput>
<table border="2">
<tr>
<td> ID </td><td> Name </td>
</tr>
<cfloop query="queryData">
<tr>
<td>#id#</td><td>#name#</td> </tr>
</cfloop>
</table>
</cfoutput>
Problem is -
1) it doesn't appear as normal excel file. It looks like plain file.(doesn't appear lines of rows and column)
2) HTML contents of my index.cfm file gets uploaded in this excel file. How to avoid this HTML contents?
I want to export query result in column-row format in excel sheet.
Thanks in advance.
Regards,
Manjusha
Manjusha,
The only thing I see different in your approach from the one I've done is the cfloop
Here is the base of what I have:
CODE
<cfheader name="content-disposition" value="attachment; filename=AddressBook.xls">
<cfif NotIE>
<cfcontent type="application/vnd.ms-excel">
<cfelse>
<cfcontent type="text/html">
</cfif>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head></head>
<body>
<table border="1">
<tr><th align="left" colspan="7">Address Book</th></tr>
<tr valign="bottom">
<th align="left" class="report">Contact name</th>
<th class="report">Initials</th>
<th align="left" class="report">Project title</th>
<th align="left" class="report">Address</th>
<th align="left" class="report">Phone</th>
<th align="left" class="report">Fax</th>
<th align="left" class="report">Email</th>
</tr>
<cfoutput query="AddrInfo" group="corpName">
<tr bgcolor="##cccccc"><th align="left" colspan="7" class="report">#corpName#</th></tr>
<cfoutput>
<tr valign="top">
<td class="report">#Trim(fullName)#</td>
<td align="center" class="report"><cfif Len(initials)>#Trim(initials)#<cfelse><em>N/A</em></cfif></td>
<td class="report"><cfif Len(projTitle)>#Trim(projTitle)#<cfelse> </cfif></td>
<td class="report"><cfif Len(address1) + Len(address2) + Len(city) + Len(state) + Len(zip) + Len(country)>
<cfif Len(address1)>#Trim(address1)#</cfif>
<cfif Len(address2)><br>#Trim(address2)#</cfif>
<cfif Len(city)><br>#Trim(city)#</cfif><cfif Len(state)>, #Trim(state)#</cfif><cfif Len(zip)> #Trim(zip)#</cfif>
<cfelse> </cfif>
</td>
<td class="report"><cfif Len(phone)>#Trim(phone)#<cfelse> </cfif></td>
<td class="report"><cfif Len(fax)>#Trim(fax)#<cfelse> </cfif></td>
<td class="report"><cfif Len(email)>#Trim(email)#<cfelse> </cfif></td>
</tr>
</cfoutput>
<tr><td colspan="7" class="report"> </td></tr>
</cfoutput>
</table>
This creates an excel file that has definate rows and columns
| 