I haven't followed this thread closely, but it's disappointing when one
asks for help, gets a lot of it, then finds a solution, and doesn't
share it.
How can we learn from your efforts, Jeff?
Forrest C. Gilmore
=============================
On 3/27/2014 6:39 PM, Jeff Howard wrote:
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 <mailto: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>
[mailto:ad...@acfug.org <mailto:ad...@acfug.org>] *On Behalf Of
*Jason Delmore
*Sent:* Tuesday, March 18, 2014 12:31 AM
*To:* discussion@acfug.org <mailto: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>
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------