Skip to Content
0
Nov 02, 2012 at 06:10 AM

Header Row in EXCEL Sheet attachment of eMail Receiver Adapter

43 Views

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.