I would like to output an excel template with one of the columns having cells containing values from a pick list.
From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template.
However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution.
Thanks
