Skip to main content
  • EN

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

 

 

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


Community Stats

30,112
Posts
114,303
Replies
37,745
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.