Writing a list of values to a spreadsheet in ColdFusion 9

So I have a comma delimited list of emails. I want to take this list and write it to a spreadsheet. The first thing I am going to do is create a component that I can reuse throughout my application named email list writer. The components write method will take a list of emails and an absolute filename. /** * @output false */ component { public EmailListWriter function init(){ return this; } public void function write(String emails,String filename){ var ss = spreadsheetNew("EmailAlerts"); // for each email in the list add a new row for(i=1; i <= listLen(arguments.emails); ++i){ spreadsheetAddRow(ss,listGetAt(arguments.emails,i)); } // create the spreadsheet spreadsheetWrite(ss,arguments.filename,true); } }

Now that was pretty easy. If we wanted to serve this up to our users as a download we could do this. <cfset emails = "whohas@aol.com,whohas@hotmail.com"> <cfset filename = expandPath('.') & "\temp\EmailAlerts.xls"> <cfset application.emaillistWriter.write(emails,filename)> <cfheader name="Content-Disposition" value="attachment;filename=EmailAlerts.xls"> <cfcontent type="application/msexcel" file="#filename#"> <cfabort>

This entry was posted on December 15, 2009 at 4:13 PM and has received 2181 views. Comments 2 | Print this entry.