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?
Have something to add?