Can FME create complex Excel outputs?

Hello, you can use the ExcelStyler to style your Excel output files: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/excelstyler.htm 

For a project in which I regularly had to create Excel reports with the same layout, I did the following: before writing I used a PythonCaller to copy the template file. I then wrote my data to the copy and I used another PythonCaller to rename the written output.

Thanks!  I’ll take a look again at the ExcelStyler.  I looked at it previously, but didn’t seem to think that was going to get me what I needed in the end.   The PythonCaller is new to me, so I’ll definitely look into that one and see how using that along with the ExcelStyler will get me the needed output.

Hi @bec 

I believe this post will be interesting for you https://community.safe.com/transformers-9/xls-writer-set-specific-cell-value-13373

I believe a good template, together with setting the column position and the row number can do the trick.

Jasper

As @jasperwis said a template is the best option here. You can also write to named ranges, see here for an example:
https://support.safe.com/s/article/using-a-template-file-when-writing-excel-data

Thanks for all of the insight on how to go about getting the data output needed in the end.  I definitely agree a template is the best option.  And the other information provided by jasperwis and hkingsbury will certainly help.  Appreciate the input from everyone!