Good stuff, Jason. And I'll add, Jeff, that there are indeed other options for dealing with spreadsheets in CFML, and some have been shared by others here. I have a list of them as a category in my CF411 site:
http://www.cf411.com/excel There may be many more than most realize, and Jeff perhaps another will work for your particular need if one of these shared so far do not. /charlie PS Still looking for clarification on your version and update level, in case that may well be a problem. From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jason Delmore Sent: Tuesday, March 18, 2014 12:31 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Re: cfspreadsheet etc. question I think you are reading the whole sheet in when you use CFSPREADSHEET and essentially setting the pointer to sheet 2 with the second CFSPREADSHEET line. So you are trying to overwrite the existing spreadsheet with the same objects and CF doesn't like that. Maybe you should try something like this (I haven't touched CFSPREADSHEET so I could be way off) <cfspreadsheet action="read" src="#application.rootDir#assets\C3d\IgG_Single_Template.xlsm" name="Patient_Output"> <cfset SpreadsheetSetCellValue(Patient_Output,patientResults.patientName,7,5)> <cfset SpreadsheetSetCellValue(Patient_Output,patientResults.clinic,8,5)> <cfset SpreadsheetSetCellValue(Patient_Output,DateFormat(patientResults.patientDOB, "mm/dd/yyyy"),9,5)> <cfset SpreadsheetSetCellValue(Patient_Output,DateFormat(patientResults.sampleDate, "mm/dd/yyyy"),10,5)> <cfset SpreadsheetSetCellValue(Patient_Output,DateFormat(patientResults.reportDate, "mm/dd/yyyy"),11,5)> <cfset SpreadsheetSetCellValue(Patient_Output,patientResults.doctor,12,5)> <cfset SpreadsheetSetCellValue(Patient_Output,"link goes here",13,3)> <cfset SpreadsheetSetActiveSheetNumber(Patient_Output, 2)> <!--- here is where the magic is... ---> <cfloop from="1" to="20" index="i"> <cfset SpreadsheetSetCellValue(Patient_Output,".5",2,2)> </cfloop> <!--- Write both sheets to the new file. ---> <cfspreadsheet action="write" filename="#theFile#" name="Patient_Output" overwrite="true"> <!--- Redirect user to the patient spreadsheet. ---> <cflocation url="/C3d/individual_results/#patientResults.lname#.xlsm"> I did CFXL using POI a number of years back. It's on riaforge. If nothing else, looking at the code may give you some inspiration if you decide to delve into POI. Best wishes, Jason ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
