I have a XML structure like below. How to write a groovy script to write XML data to xls(Excel)? Could someone help me on this?
<Record>
<Action>create</Action>
<ID KEMASAN>DUS, 1 BOTOL PLASTIK @ 28 TABLET</ID KEMASAN>
<Barcode>(01)00372626270113(21)200000022671(17)(10)ICS_DECOM</Barcode>
<Barcode>(01)00372626270113(21)200000022670(17)(10)ICS_DECOM</Barcode>
<Barcode>(01)00372626270113(21)200000000052(17)(10)ICS_DECOM</Barcode>
<NIE>DKI1844200317A1</NIE>
<LOT NO>ICS_DECOM</LOT NO>
<Exp Date>31/12/2024</Exp Date>
<Batch No>ICS_DECOM</Batch No>
<GTIN>00372626270113</GTIN>
<IS_ACTIVE>TRUE</IS_ACTIVE>
<IS_SAMPLE>FALSE</IS_SAMPLE>
<IS_REJECT>FALSE</IS_REJECT>
<MFG DATE>01/01/2023</MFG DATE>
<Case SGTIN>urn:epc:id:sgtin:0372626.527011.200000000052</Case SGTIN>
<Pallet SGTIN>urn:epc:id:sscc:0361958.0001046962</Pallet SGTIN>
</Record>
<Record>
<Action>create</Action>
<ID KEMASAN>DUS, 1 BOTOL PLASTIK @ 28 TABLET</ID KEMASAN>
<Barcode>(01)00372626270113(21)200000022671(17)(10)ICS_DECOM</Barcode>
<Barcode>(01)00372626270113(21)200000022670(17)(10)ICS_DECOM</Barcode>
<Barcode>(01)00372626270113(21)200000000052(17)(10)ICS_DECOM</Barcode>
<NIE>DKI1844200317A1</NIE>
<LOT NO>ICS_DECOM</LOT NO>
<Exp Date>31/12/2024</Exp Date>
<Batch No>ICS_DECOM</Batch No>
<GTIN>00372626270113</GTIN>
<IS_ACTIVE>TRUE</IS_ACTIVE>
<IS_SAMPLE>FALSE</IS_SAMPLE>
<IS_REJECT>FALSE</IS_REJECT>
<MFG DATE>01/01/2023</MFG DATE>
<Case SGTIN>urn:epc:id:sgtin:0372626.527011.200000000052</Case SGTIN>
<Pallet SGTIN>urn:epc:id:sscc:0361958.0001046962</Pallet SGTIN>
</Record>
Unable to write XSLT from given XML