Question

excel writer

  • 18 February 2020
  • 1 reply
  • 3 views

Badge +1

Good morning

Can someone advise how i do the following

I have 1 excel spreadsheet (data.xlsx) and 1 empty excel spreadsheet (template.xlsc)

I want to write the contents of data.xlsx to template.xlsx and output it as result.xlsx

How do i write the map the columns from data.xlsx to the template? It does automatically write correctly, but i would like to know how to specifically write one column to another before i output

 

The contents of the data.xlsx file i've uploaded are only test, but i would like to know how to do this so i can do the task in the future using proper data

 

thanks

Simon Hume

 

 


1 reply

Badge +4

Hi Simon,

 

I've had the best results by setting up my template with named ranges for FME to write into. In your example template file, if you selected cells A2:A4 then gave them a name in the Name box, you can tell your writer to write to only that range of cells.

You then modify your writer to look something like this: SheetName/NamedRange. In this example, template/MyInfo

This will allow you to write data to only this part of your excel template. I'm sure there are other ways to accomplish what you're asking, but I've found this works quite well.

Reply