In an effort to get this done I condensed the template down to 1 spreadsheet with the data for the charts located at the bottom for the first sheet. When I complete the migration to a CF10 server I may revisit this but for the time being I found a method to get this to work.
On Tue, Mar 18, 2014 at 11:52 AM, Charlie Arehart <char...@carehart.org>wrote: > 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- >
