Unable to convert the data to xml

narasimha gudisa <[email protected]> Thu, 25 May 2023 18:18:15 +0530
Newsgroups gmane.comp.jakarta.velocity.user
Message-ID <CAAuhOk32cTikj37RhmHa_u-aNEL+XJNytc4j0b7Wrvw4Wu9=nA@mail.gmail.com>
--00000000000067f5c505fc8409cc
Content-Type: text/plain; charset="UTF-8"

Hello, I have data in the excel file I would like to convert the data to
the xml format using the apache velocity transformation engine.

My template  :

<?xml version="1.0" encoding="UTF-8"?>
<root>
#foreach ($line in $data)
<row>
    <timestamp type = "string">$(line.Timestamp(optional))</timestamp>
 <targettype type = "string">$line.Target Type</targettype>
<targetname type = "string">$line.Target Name</targetname>
<blockingevent type = "string">$line.Blocking
Event(optional)</blockingevent>
 <message type = "string">$line.Message</message>

</row>
#end
</root>

Getting the output :

<root>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
<row>
<timestamp type="string">$(line.Timestamp(optional))</timestamp>
<targettype type="string">$line.Target Type</targettype>
<targetname type="string">$line.Target Name</targetname>
<blockingevent type="string">$line.Blocking Event(optional)</blockingevent>
<message type="string">$line.Message</message>
</row>
</root>

I'm getting the variable names instead of data can you help me achieve this

Thanks in advance

Thanks
Narasimha Gudisa

--00000000000067f5c505fc8409cc--