ColdFusion - spreadsheetaddrows errors out

when trying use includecolumnnames parameter cf throw , error saying the  spreadsheetaddrows function supports 2 6 parameters, documentation shows 7. example in spreadsheetaddrows documentation fails:

 

<cfscript>

    out_fl = "#expandpath("./")#header.xlsx";

        xlobj = spreadsheetnew("2d_arr_data", true);

        qry_data = querynew("product, customer, qtr");

        queryaddrow(qry_data, {product:"aniseed syrup", customer="annie", qtr="1"});

        queryaddrow(qry_data, {product:"camembert pierrot", customer="pierre", qtr="2"});

        queryaddrow(qry_data, {product:"scones", customer="connie", qtr="4"});

    datatype = [""];

        spreadsheetaddrows(xlobj, qry_data,1,1,"true",datatype,true);

        cfspreadsheet(action="write", filename="#out_fl#", name="xlobj", overwrite=true);

        cfspreadsheet(action="read", src="#out_fl#", query="qryxl");

        writedump(qryxl);

</cfscript>

moving coldfusion

More discussions in ColdFusion

adobe