topic Write in Excel format in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/write-in-excel-format/m-p/13865421#M2030948 <P>Hello,</P><P>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 <STRONG>.dat</STRONG> format</P><P>Example file name: weekly<STRONG>.</STRONG>sales<STRONG>.</STRONG>may<STRONG>.dat</STRONG>&nbsp; &nbsp; &nbsp;(Interfaces\OUT\<STRONG>weekly.sales.may.dat</STRONG>)</P><P>In AL11 transaction when I double click this file the example data is as below,</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">&lt;?xml version="1.0"?&gt; &lt;Batch&gt; &lt;Record&gt;&lt;OCR&gt;0200&lt;/OCR&gt;&lt;TXTMT&gt;&lt;![CDATA[0200 Metals/Condensa]]&gt;&lt;/TXTMT&gt;&lt;YEAR&gt;2013&lt;/YEAR&gt;&lt;BUKRS&gt;1000&lt;/BUKRS&gt;&lt;COST_CENTER&gt;034181129V&lt;/COST_CENTER&gt;&lt;ACCOUNT&gt;0062500377&lt;/ACCOUNT&gt;&lt;FAREA&gt;A310&lt;/FAREA&gt;&lt;MATKL&gt;&lt;![CDATA[XX]]&gt;&lt;/MATKL&gt;&lt;TSL&gt;5502.10&lt;/TSL&gt;&lt;MSL&gt;59.270&lt;/MSL&gt;&lt;UNIT&gt;KG&lt;/UNIT&gt;&lt;REGIO&gt;CA&lt;/REGIO&gt;&lt;KOSAR&gt;L&lt;/KOSAR&gt;&lt;ABTEI&gt;&lt;![CDATA[31544]]&gt;&lt;/ABTEI&gt;&lt;FCNTRFTUR&gt;&lt;![CDATA[HARDITM4735702]]&gt;&lt;/FCNTRFTUR&gt;&lt;DESCRIPTION&gt;&lt;![CDATA[(BLK)A SEELIGSON]]&gt;&lt;/DESCRIPTION&gt;&lt;RABUNODE&gt;&lt;/RABUNODE&gt;&lt;/Record&gt; &lt;Record&gt;&lt;OCR&gt;0200&lt;/OCR&gt;&lt;TXTMT&gt;&lt;![CDATA[0200 Metals/Condensa]]&gt;&lt;/TXTMT&gt;&lt;YEAR&gt;2013&lt;/YEAR&gt;&lt;BUKRS&gt;1000&lt;/BUKRS&gt;&lt;COST_CENTER&gt;034181129V&lt;/COST_CENTER&gt;&lt;ACCOUNT&gt;0062500377&lt;/ACCOUNT&gt;&lt;FAREA&gt;A310&lt;/FAREA&gt;&lt;MATKL&gt;&lt;![CDATA[XX]]&gt;&lt;/MATKL&gt;&lt;TSL&gt;5502.10&lt;/TSL&gt;&lt;MSL&gt;59.270&lt;/MSL&gt;&lt;UNIT&gt;KG&lt;/UNIT&gt;&lt;REGIO&gt;CA&lt;/REGIO&gt;&lt;KOSAR&gt;L&lt;/KOSAR&gt;&lt;ABTEI&gt;&lt;![CDATA[31544]]&gt;&lt;/ABTEI&gt;&lt;FCNTRFTUR&gt;&lt;![CDATA[HARDITM4735702]]&gt;&lt;/FCNTRFTUR&gt;&lt;DESCRIPTION&gt;&lt;![CDATA[(BLK)A SEELIGSON]]&gt;&lt;/DESCRIPTION&gt;&lt;RABUNODE&gt;&lt;/RABUNODE&gt;&lt;/Record&gt; &lt;Record&gt;&lt;OCR&gt;0200&lt;/OCR&gt;&lt;TXTMT&gt;&lt;![CDATA[0200 Metals/Condensa]]&gt;&lt;/TXTMT&gt;&lt;YEAR&gt;2013&lt;/YEAR&gt;&lt;BUKRS&gt;1000&lt;/BUKRS&gt;&lt;COST_CENTER&gt;034181129V&lt;/COST_CENTER&gt;&lt;ACCOUNT&gt;0062500377&lt;/ACCOUNT&gt;&lt;FAREA&gt;A310&lt;/FAREA&gt;&lt;MATKL&gt;&lt;![CDATA[XX]]&gt;&lt;/MATKL&gt;&lt;TSL&gt;5502.10&lt;/TSL&gt;&lt;MSL&gt;59.270&lt;/MSL&gt;&lt;UNIT&gt;KG&lt;/UNIT&gt;&lt;REGIO&gt;CA&lt;/REGIO&gt;&lt;KOSAR&gt;L&lt;/KOSAR&gt;&lt;ABTEI&gt;&lt;![CDATA[31544]]&gt;&lt;/ABTEI&gt;&lt;FCNTRFTUR&gt;&lt;![CDATA[HARDITM4735702]]&gt;&lt;/FCNTRFTUR&gt;&lt;DESCRIPTION&gt;&lt;![CDATA[(BLK)A SEELIGSON]]&gt;&lt;/DESCRIPTION&gt;&lt;RABUNODE&gt;&lt;/RABUNODE&gt;&lt;/Record&gt; &lt;/Batch&gt;</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>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</P> Sat, 14 Sep 2024 20:49:22 GMT vihaan2018 2024-09-14T20:49:22Z Write in Excel format https://community.sap.com/t5/application-development-and-automation-discussions/write-in-excel-format/m-p/13865421#M2030948 <P>Hello,</P><P>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 <STRONG>.dat</STRONG> format</P><P>Example file name: weekly<STRONG>.</STRONG>sales<STRONG>.</STRONG>may<STRONG>.dat</STRONG>&nbsp; &nbsp; &nbsp;(Interfaces\OUT\<STRONG>weekly.sales.may.dat</STRONG>)</P><P>In AL11 transaction when I double click this file the example data is as below,</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">&lt;?xml version="1.0"?&gt; &lt;Batch&gt; &lt;Record&gt;&lt;OCR&gt;0200&lt;/OCR&gt;&lt;TXTMT&gt;&lt;![CDATA[0200 Metals/Condensa]]&gt;&lt;/TXTMT&gt;&lt;YEAR&gt;2013&lt;/YEAR&gt;&lt;BUKRS&gt;1000&lt;/BUKRS&gt;&lt;COST_CENTER&gt;034181129V&lt;/COST_CENTER&gt;&lt;ACCOUNT&gt;0062500377&lt;/ACCOUNT&gt;&lt;FAREA&gt;A310&lt;/FAREA&gt;&lt;MATKL&gt;&lt;![CDATA[XX]]&gt;&lt;/MATKL&gt;&lt;TSL&gt;5502.10&lt;/TSL&gt;&lt;MSL&gt;59.270&lt;/MSL&gt;&lt;UNIT&gt;KG&lt;/UNIT&gt;&lt;REGIO&gt;CA&lt;/REGIO&gt;&lt;KOSAR&gt;L&lt;/KOSAR&gt;&lt;ABTEI&gt;&lt;![CDATA[31544]]&gt;&lt;/ABTEI&gt;&lt;FCNTRFTUR&gt;&lt;![CDATA[HARDITM4735702]]&gt;&lt;/FCNTRFTUR&gt;&lt;DESCRIPTION&gt;&lt;![CDATA[(BLK)A SEELIGSON]]&gt;&lt;/DESCRIPTION&gt;&lt;RABUNODE&gt;&lt;/RABUNODE&gt;&lt;/Record&gt; &lt;Record&gt;&lt;OCR&gt;0200&lt;/OCR&gt;&lt;TXTMT&gt;&lt;![CDATA[0200 Metals/Condensa]]&gt;&lt;/TXTMT&gt;&lt;YEAR&gt;2013&lt;/YEAR&gt;&lt;BUKRS&gt;1000&lt;/BUKRS&gt;&lt;COST_CENTER&gt;034181129V&lt;/COST_CENTER&gt;&lt;ACCOUNT&gt;0062500377&lt;/ACCOUNT&gt;&lt;FAREA&gt;A310&lt;/FAREA&gt;&lt;MATKL&gt;&lt;![CDATA[XX]]&gt;&lt;/MATKL&gt;&lt;TSL&gt;5502.10&lt;/TSL&gt;&lt;MSL&gt;59.270&lt;/MSL&gt;&lt;UNIT&gt;KG&lt;/UNIT&gt;&lt;REGIO&gt;CA&lt;/REGIO&gt;&lt;KOSAR&gt;L&lt;/KOSAR&gt;&lt;ABTEI&gt;&lt;![CDATA[31544]]&gt;&lt;/ABTEI&gt;&lt;FCNTRFTUR&gt;&lt;![CDATA[HARDITM4735702]]&gt;&lt;/FCNTRFTUR&gt;&lt;DESCRIPTION&gt;&lt;![CDATA[(BLK)A SEELIGSON]]&gt;&lt;/DESCRIPTION&gt;&lt;RABUNODE&gt;&lt;/RABUNODE&gt;&lt;/Record&gt; &lt;Record&gt;&lt;OCR&gt;0200&lt;/OCR&gt;&lt;TXTMT&gt;&lt;![CDATA[0200 Metals/Condensa]]&gt;&lt;/TXTMT&gt;&lt;YEAR&gt;2013&lt;/YEAR&gt;&lt;BUKRS&gt;1000&lt;/BUKRS&gt;&lt;COST_CENTER&gt;034181129V&lt;/COST_CENTER&gt;&lt;ACCOUNT&gt;0062500377&lt;/ACCOUNT&gt;&lt;FAREA&gt;A310&lt;/FAREA&gt;&lt;MATKL&gt;&lt;![CDATA[XX]]&gt;&lt;/MATKL&gt;&lt;TSL&gt;5502.10&lt;/TSL&gt;&lt;MSL&gt;59.270&lt;/MSL&gt;&lt;UNIT&gt;KG&lt;/UNIT&gt;&lt;REGIO&gt;CA&lt;/REGIO&gt;&lt;KOSAR&gt;L&lt;/KOSAR&gt;&lt;ABTEI&gt;&lt;![CDATA[31544]]&gt;&lt;/ABTEI&gt;&lt;FCNTRFTUR&gt;&lt;![CDATA[HARDITM4735702]]&gt;&lt;/FCNTRFTUR&gt;&lt;DESCRIPTION&gt;&lt;![CDATA[(BLK)A SEELIGSON]]&gt;&lt;/DESCRIPTION&gt;&lt;RABUNODE&gt;&lt;/RABUNODE&gt;&lt;/Record&gt; &lt;/Batch&gt;</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>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</P> Sat, 14 Sep 2024 20:49:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/write-in-excel-format/m-p/13865421#M2030948 vihaan2018 2024-09-14T20:49:22Z