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 (InterfacesOUTweekly.sales.may.dat)
In AL11 transaction when I double click this file the example data is as below,
<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