0 Replies Latest reply on Aug 5, 2010 10:26 AM by Fordian-Slip

    CF9 & CFSpreadsheet

    Fordian-Slip Level 1

      Hi Folks -

       

      I have a relatively simple question:

       

      What is wrong with this:

      <cfset schedRpt = spreadsheetNew()>
      <cfset SpreadsheetAddRows(schedRpt, "test",1,1,1)>

      <cfset SpreadsheetAddRows(schedRpt, "test,test1")>

       

      I have used all the parameters and all combinations of the parameters to add in my row, and nothing works.

       

       

      When I add info using a query, it works fine -

      <cfset schedRpt = spreadsheetNew()>

      <cfset SpreadsheetAddRows(schedRpt, data)>

       

      Easy to use, and it's nice, but I may want to add in different pieces or perhaps manipulate the information first

      or perhaps calculate something, and then add the information into the spreadsheet.

       

      But when I add in text directly, I get a blank sheet.

       

      Does anybody have any ideas?

       

      Thanks,

       

      Doug