Header Row in EXCEL Sheet attachment of eMail Receiver Adapter

[former_member201264]

HI Gurus,

I am able to send EXCEL Sheet as an attached file to my Mail receiver Adapter successfully.

But in the EXCEL Sheet, I need  Header Row in EXCEL Sheet attachment of eMail Receiver Adapter.

Example: pay load

<Record>

     <Name>John</Name>

     <City>Chicago</City>

</Record>

<Record>

     <Name>David</Name>

     <City>Newyork</City>

</Record>

When I send this data to excel attachement at the receiver mail adapter, i am getting as below:

John | Chicago

David| Newyork

But I need this data to excel attachement at the receiver mail adapter,  as below:

Name|City  -----> Here these are your column heading from Payload XML tags

John | Chicago

David| Newyork

Please help me, any method or suggestion and any code or any thing to solve this issue.

Regards,

Sreeni.

[former_member201264 · Accepted solution]

Hi ,

I did  this by adding one XML line of code

<xsl:copy-of select="ns0:MT_SCG_GEM_eMailNotifications/node()" />

in XSL achieved.

I also tried in your way, it is also good idea then XSLT but i did the same using XSL Mapping.

See this link: Adding new record as a Tag using  XSLT Mapping

Thank you.

Regards,

Sreeni.