I have tried all sorts of workarounds for this issue. I just tried splitting the excel workbook into two separate workbooks and then combining them in the last step and I keep getting the same error when trying to add the second sheet to the workbook.
Anyone ever had this issue and know how to resolve it? The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request An exception occurred while using action=update. org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the name '/xl/drawings/drawing2.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12] Resources: - Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option. - Check the ColdFusion documentation <http://www.adobe.com/go/prod_doc>to verify that you are using the correct syntax. - Search the Knowledge Base <http://www.adobe.com/go/prod_support/> to find a solution to your problem. Browser Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0 Remote Address 108.73.189.89 Referrer http://dunwoodylabs.com/office/loginForm.cfm Date/Time 14-Mar-14 11:58 AM On Thu, Mar 13, 2014 at 11:25 PM, Jeff Howard <jeh...@gmail.com> wrote: > I'm using CF 9 to try and create a spreadsheet from a template. The > spreadsheet has 2 sheets, 1 that has charts on it, 2 contains the data used > to create the charts. > > The data for sheet 2 is stored in MS SQL database and I'm querying that > and trying to write to the second sheet that contains the formulas to have > the charts auto-generated. > > I'm getting the following error message when I try to update the sheet > that contains the data that I wrote to sheet 2. The updates work for sheet > 1 but when I try to update sheet 2 I get the error. > > An exception occurred while using action=update. > java.lang.IllegalArgumentException: The workbook already contains a sheet > of this name > > > Here is the code (I simplified the loop to try for testing/dev): > > > <cfspreadsheet action="read" > src="#application.rootDir#assets\C3d\IgG_Single_Template.xlsm" > name="Patient_Output" sheet="1"> > <cfspreadsheet action="read" > src="#application.rootDir#assets\C3d\IgG_Single_Template.xlsm" > name="newCalc_P1" sheet="2"> > <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)> > <cfloop from="1" to="20" index="i"> > <cfset SpreadsheetSetCellValue(newCalc_P1,".5",2,2)> > </cfloop> > <!--- Write both sheets to the new file. ---> > <cfspreadsheet action="write" filename="#theFile#" name="Patient_Output" > overwrite="true"> > <cfspreadsheet action="update" filename="#theFile#" name="newCalc_P1" > sheetname="newCalc_P1"> > <!--- Redirect user to the patient spreadsheet. ---> > <cflocation url="/C3d/individual_results/#patientResults.lname#.xlsm"> > > > Any help would be greatly appreciated. > > Thanks in advance, > Jeff >
