cfspreadsheet in CF2016 doing weird things

Explorer ,
Mar 24, 2017 Mar 24, 2017

Copy link to clipboard

Copied

We have a little report that writes new data to a pre-existing Excel file that has been working for a while.  Recently upgraded to 2016 and apparently didn't test this report!

<cfspreadsheet action="read"

        src="#application.loadpath#\#Session.NewWorking#"

        name="sObj"

        SHEET="2" />

<cfscript>

spreadsheetSetCellValue(sObj,#val(RA)#,2,2);

spreadsheetSetCellValue(sObj,#val(AP)#,3,2);

spreadsheetSetCellValue(sObj,#val(GetCHAP.showvalue)#,4,2);

spreadsheetSetCellValue(sObj,#val(GetFP.showvalue)#,5,2);

spreadsheetSetCellValue(sObj,#val(getrad.showvalue)#,6,2);

spreadsheetSetCellValue(sObj,#val(GetClosed.showvalue)#,7,2);

</cfscript>

<cfspreadsheet action="write" overwrite="true"

        filename="#application.loadpath#\#Session.NewWorking#"

        name="sObj" />

Previously it would update that data on the 2nd worksheet in the workbook.   Now it deletes all of the other worksheets in the workbook...    Any one have ideas or fixes for this?

Views

160

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation