Populating a spreadsheet with an array using SpreadsheetAddrows

I think your issue is two-fold.

1) attributes.ColumnHeader doesn't sound like the sort of variable name which would hold an array to me.  It sounds like a string.  Is it an array?

2) there's a bug in spreadsheetAddRows() in that with an array, one must specify the row/column values.

This code works:

<cfscript>
    oX = spreadsheetNew("withArray");

    a = ["tahi", "rua", "toru", "wha"];
    spreadsheetAddRows(oX, a, 1, 1);

    sXlsPath= expandPath("./withArray.xls");
   
    spreadsheetWrite(oX, sXlsPath, true);
</cfscript>

<cfheader name="content-disposition" value="attachment; filename=#getFileFromPath(sXlsPath)#">
<cfcontent file="#sXlsPath#" reset="true" type="application/spreadsheet">

However according to the docs, I should be able to simply do this:

spreadsheetAddRows(oX, a);

ie: without specifying row/column values.  However this errors with:

An exception occurred while calling the function addRow.
java.lang.IllegalArgumentException: Invalid row number (-1) outside allowable range (0..65535)

So it looks like the internal workings of CF isn't defaulting its arguments properly.  I think this error msg is a bit sh!t, btw:  spreadsheetAddRows() should not be throwing errors relating to whatever other functions it is calling internally, because this is of no relevance to me: I'm calling spreadsheetAddRows() not addRow(), and it's misleading.  It should be catching internally-raised exceptions and then throwing its own exceptions.  Sloppy coding there from Adobe, IMO.

Anyway, it looks to me like you're passing a string when you ought to be passing an array.  And that's your problem.  it's difficult to be sure with the amount of code you supply though (if you're using variables, always include the code that sets the variable!).

--

Adam