Highlighted

cfspreadsheet in CF2016 doing weird things

Explorer ,
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

147

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

cfspreadsheet in CF2016 doing weird things

Explorer ,
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

148

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
Mar 24, 2017 0

Have something to add?

Join the conversation