exportQuestionResponsesToExcel()

Overview

public any function exportQuestionResponsesToExcel(
      required string  questionId       
    , required string  exportFields     
    ,          string  filterExpressions
    ,          string  savedFilters     
    ,          boolean writeToFile       = false
    ,          any     logger           
    ,          any     progress         
)

Exports the responses to the given question to an excel spreadsheet. Returns a workbook object (see Working with spreadsheets).

Arguments

Name	Type	Required	Description
questionId	string	Yes	ID of the question you wish to produce spreadsheet for
exportFields	string	Yes
filterExpressions	string	No
savedFilters	string	No
writeToFile	boolean	No (default=false)	Whether or not to write output to file. If true, output is written to file and the file path is returned. If false, workbook object is returned.
logger	any	No	Logger for background task export logging
progress	any	No	Progress reporter object for background task progress reporting