Skip to main content
Question

Write to Excel template header into specific cells

T
Forum|alt.badge.img

I have created an Excel template to be used as backup for billing expenses. The invoice has a header with specific places for billing date range(start, end), project name, project number, and project manager. The final output has a separate sheet for each project number. I have added AttributeManager to get rid of all of the other attributes and only have the 5 I need to insert into my template - the itemization is added later. I have everything working except getting the aggregated attribute value (i.e. project name) added to the named cell. How do I specify where to write each attribute?

Version 2018.1 Desktop

3 replies

ebygomm
Influencer
Forum|alt.badge.img+34
  • ebygommInfluencer
  • Influencer
  • April 18, 2019

To write to a named range (which I think is what you're asking), in the writer against Sheet name you use

<<Sheet Name>>/<<Named Range>>

e.g.

T
Forum|alt.badge.img
  • tsurveyor
  • Author
  • April 19, 2019
ebygomm wrote:

To write to a named range (which I think is what you're asking), in the writer against Sheet name you use

<<Sheet Name>>/<<Named Range>>

e.g.

what I don't understand is how to get attribute A into cell B4, attribute B into cell D4, attribute C into cell B5... excel attached. Writing to a named range would put everything starting at the upper corner and write the attributes in order. If all else fails I can put the dates under the other fields and use one range, but the documentation says I can use multiple named ranges. The response to my question still only refers to one named range. How do I get the attributes into more than one named range?

Billing_PN_Template.xlsx

pratap
Contributor
Forum|alt.badge.img+11
  • pratapContributor
  • Contributor
  • April 22, 2019

Kindly place the settings as shown in workspace attached

safeupdate.fmw

Reply


Helpful Members This Week

Community Stats

31,223
Posts
118,404
Replies
38,824
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.