Skip to main content
P
pmlink360
Known Participant
May 31, 2014
Question

Can you specify the columns that get written to a spreadsheet when using the query attribute of cfspreadsheet?

  • May 31, 2014
  • 1 reply
  • 305 views

Hello, I wanted to see if you can control which columns from a query get written to a excel spreadsheet. I have some items in my query that I do not want in the spreadsheet but need for my query, if that makes sense.

Thanks.

Steve

    This topic has been closed for replies.

    1 reply

    EddieLotter
    EddieLotter
    Inspiring
    June 3, 2014

    There are no parameters in the cfSpreadsheet tag to choose specific columns, however you can use a query of queries (About Query of Queries - ColdFusion English Documentation - Adobe Learning Resources) to get a query object with a subset of columns to pass to the tag.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices