Hi. I need to convert all the values from each row in an Excel sheet to a different word doc. Is this possible woth fme? With the custom transformer TableAdder I could convert the whoke sheet, but I need to create different word docs for eacht row. Each row had a unique value in the field KEY and it would be usefull to add the KEY value to the word filename.
Question
Converting each row in Excel to a different word document
+36
Use a featureWriter. Set the Format to Microsoft Word and the Dataset to C:\\newname_@Value(KEY).docx
Use MSWordStyler transformers to set the contents of the Word file. Keep in mind that the order Features enter the FeatureWriter controll the order of the files created and the order of text within the Word file.