In my previuos post I’d explained how to create an excel file using a custom code that I’d taken from github but it only supports String Text when the data is written in the excel. So, I’ve developed a single module to convert the data with support with numeric formats.
Input:
<?xml version="1.0" encoding="UTF-8"?>
<ns1:MT_Employees_res xmlns:ns1="http://LGCY/reciveEmployees">
<Empleados>
<Date>20221118</Date>
<EmployeeId>12312312</EmployeeId>
<Paycode>222</Paycode>
<UsageHours>1</UsageHours>
<UsageUnits>2</UsageUnits>
<ChargeLocationType>MX</ChargeLocationType>
<Location>ABC</Location>
<Department>XX</Department>
<ReasonCode>300</ReasonCode>
</Empleados>
<Empleados>
<Date>20221118</Date>
<EmployeeId>12312312</EmployeeId>
<Paycode>222</Paycode>
<UsageHours>1</UsageHours>
<UsageUnits>2</UsageUnits>
<ChargeLocationType>MX</ChargeLocationType>
<Location>ABC</Location>
<Department>XX</Department>
<ReasonCode>300</ReasonCode>
</Empleados>
</ns1:MT_Employees_res>
Output:
Let’s get started:
Seguir leyendo