Output ColdFusion database query as Excel file with filename specified

By Dora -
I guess the title of this post tells it all.  And really, it is no different from your normal ColdFusion queries except that you add in the first two lines at the top.

You can refer to Adobe's docs on this as well.

<cfcontent type="application/msexcel">
<cfheader name="content-disposition" value="attachment;filename=customers.xls">

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
<title>Customers</title>
</head>

<body>

<cfquery name="getcustomers" datasource="custDB" dbtype="ODBC" >
select * from customers where companyid='#companyid#'
</cfquery>

<h1>Customers</h1>

<table width="100%" border=1>
<tr>
<th>Customer name</th>
<th>Customer email</th>
</tr>

<cfoutput query="getcustomers">
<tr>
<td>#customername#</td>
<td>#customeremail#</td>
</tr>
</cfoutput>

</table>

</body>
</html>

Comments

Post a Comment

Popular posts from this blog

How to create an organizational chart in your webpage using Google Organization Chart Tools

By Dora -
Image
https://developers.google.com/chart/interactive/docs/gallery/orgchart While googling for some information on organizational charts of various companies, I came across this cool visualization tool on Google Developers. If you are comfortable with JavaScript and want a quick and easy way to churn out a simple organizational chart that displays on a webpage, this tool is quite useful. Organizational chart churned out using Google's Visualization OrgChart object To use it, follow these few steps Step 1: Include this tag in your <head> tag in your HTML file <script type = 'text/javascript' src = 'https://www.google.com/jsapi' ></script> Step 2: Load visualization package and set callback method when page loads In this case, the callback method is "drawChart". <script type = 'text/javascript' >       google . load ( 'visualization' , '1' , { packages :[ 'orgchart' ]});     ...
Read more

Embed JSX code with if condition in React app

By -
     renderPrice(pt)  {    if (pt.amountpaid!="") {        let ctrl = (           <>             <div>                 <label>Price</label><br/>                 <input type="text" readOnly name="amountpaid" value={pt.amountpaid} />             </div>           </>          );          return ctrl;     } //end if } //end renderPrice render () {   const   priceElement  =  this . renderPrice ( purchasetransaction ); return  (                  < div   style = { { marginTop :   '5em' , marginLeft : '2em' } } >  ...
Read more