Is it possible to format an Excel file with FME to create drop-down lists (function data validation in Excel)? I have multiple excel files that need multiple drop-down lists and a supplier excel sheet with all values. In total there are hundreds of drop-down lists that need to be created, therefore wonder if there could be some solution available with FME.
@someliene FME can't create the drop down lists. If you have the lists already defined, then FME can probably use a template file that would carry them across to the target Excel file.