Getting stats from Soundings using cfspreadsheet
Posted:

I'm hoping to post this over on soundings.riaforge.org later but I am having trouble with the site. Plus also thought good to throw out here.

Below I have hacked at the Sounding app by Ray (ColdFusion Jedi) Camdon to use cfspreadsheet to create the Excel stat sheet. All this code I have put in the IF block stating "form.format is 'excel'". It requires the query "getSurveyTakers" which should be just before it.

//Use an absolute path for the files. ---> theFile = expandPath( "report.xls" ); //Create empty ColdFusion spreadsheet objects. ---> theSheet = SpreadsheetNew("CourseData"); //Populate object with a query. ---> SpreadsheetAddRows(theSheet,reportQry);

There might be more efficient (read: quicker) ways of doing the above so always happy for feedback!

comments powered by Disqus
© AndyJarrett 2013 | RSS Feed