tracker issue : CF-3914895

Duplicate ID:	CF-3043160

Try the following code from the docs:

<cfquery 
       name="courses" datasource="cfdocexamples"
       cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#"> 
       SELECT CORNUMBER,DEPT_ID,COURSE_ID,CORNAME 
       FROM COURSELIST 
</cfquery> 
  
<cfscript> 
    ///We need an absolute path, so get the current directory path. 
    theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "courses.xls"; 
    //Create a new Excel spreadsheet object and add the query data. 
    theSheet = SpreadsheetNew("CourseData"); 
  
    SpreadsheetAddRows(theSheet,courses); 
    SpreadsheetAddRows(theSheet,["1,a", "2,B,b"]); 
</cfscript> 

<cfspreadsheet action="write" filename="#theFile#" name="theSheet" 
    sheet=1 sheetname="courses" overwrite=true>

It throws an error: 	Invalid row number (-1) outside allowable range (0..65535)

This is a rather crucial thing we need to fix as this one of the few places where we can pass an array to the spreadsheet functions. All the others want a query or a list, and using a list is dangerous as a value may include a comma.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3914895

External Customer Info:
External Company:  
External Customer Name: cfjedimaster
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments: