Write in Excel format

[vihaan2018]

Hello,

Currently one of our custom program is writing the Sales data as XML format in the App server by using OPEN DATASET/TRANSFER syntax the file is .dat format

Example file name: weekly.sales.may.dat     (Interfaces\OUT\weekly.sales.may.dat)

In AL11 transaction when I double click this file the example data is as below,

<?xml version="1.0"?>
<Batch>

<Record><OCR>0200</OCR><TXTMT><![CDATA[0200  Metals/Condensa]]></TXTMT><YEAR>2013</YEAR><BUKRS>1000</BUKRS><COST_CENTER>034181129V</COST_CENTER><ACCOUNT>0062500377</ACCOUNT><FAREA>A310</FAREA><MATKL><![CDATA[XX]]></MATKL><TSL>5502.10</TSL><MSL>59.270</MSL><UNIT>KG</UNIT><REGIO>CA</REGIO><KOSAR>L</KOSAR><ABTEI><![CDATA[31544]]></ABTEI><FCNTRFTUR><![CDATA[HARDITM4735702]]></FCNTRFTUR><DESCRIPTION><![CDATA[(BLK)A SEELIGSON]]></DESCRIPTION><RABUNODE></RABUNODE></Record>

<Record><OCR>0200</OCR><TXTMT><![CDATA[0200  Metals/Condensa]]></TXTMT><YEAR>2013</YEAR><BUKRS>1000</BUKRS><COST_CENTER>034181129V</COST_CENTER><ACCOUNT>0062500377</ACCOUNT><FAREA>A310</FAREA><MATKL><![CDATA[XX]]></MATKL><TSL>5502.10</TSL><MSL>59.270</MSL><UNIT>KG</UNIT><REGIO>CA</REGIO><KOSAR>L</KOSAR><ABTEI><![CDATA[31544]]></ABTEI><FCNTRFTUR><![CDATA[HARDITM4735702]]></FCNTRFTUR><DESCRIPTION><![CDATA[(BLK)A SEELIGSON]]></DESCRIPTION><RABUNODE></RABUNODE></Record>

<Record><OCR>0200</OCR><TXTMT><![CDATA[0200  Metals/Condensa]]></TXTMT><YEAR>2013</YEAR><BUKRS>1000</BUKRS><COST_CENTER>034181129V</COST_CENTER><ACCOUNT>0062500377</ACCOUNT><FAREA>A310</FAREA><MATKL><![CDATA[XX]]></MATKL><TSL>5502.10</TSL><MSL>59.270</MSL><UNIT>KG</UNIT><REGIO>CA</REGIO><KOSAR>L</KOSAR><ABTEI><![CDATA[31544]]></ABTEI><FCNTRFTUR><![CDATA[HARDITM4735702]]></FCNTRFTUR><DESCRIPTION><![CDATA[(BLK)A SEELIGSON]]></DESCRIPTION><RABUNODE></RABUNODE></Record>

</Batch>

Now the Business want to have the data in Excel format, they no longer wants in a .dat format so I need to change the program for write the data in Excel format, pls. let us know how we can achieve it? Thanks