Skip to main content
  • EN

I’m fairly new to FME.  I’m using FME Workbench 2023.1.  I am trying to recreate an excel output similar to the below image, but I’m not sure FME is capable since there isn’t much information out there on using FME to write an excel output like what I have a need for…  All I see is more simple outputs.  I need to be able tie the output values of a lot of those cells to data created in other transformers, but since the layout is not your typical excel sheet layout, I can’t seem to find any info if you can use a template and then tie the output from another transformer to the particular cell it goes with in the excel template.  If anyone knows where I can find more information on this, I would greatly appreciate the help!

 

Sample template with values

 

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!

Reply


Community Stats

30,351
Posts
115,341
Replies
38,081
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.