Skip to main content
Inspiring
March 24, 2017
Question

cfspreadsheet in CF2016 doing weird things

  • March 24, 2017
  • 0 replies
  • 231 views

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?

    This topic has been closed for replies.