topic Re: Excel Attachment Date Column in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/excel-attachment-date-column/m-p/9307477#M1726902 <HTML><HEAD></HEAD><BODY><P>Duplicate Thread.. closing this one.. original thread is at <A _jive_internal="true" href="https://answers.sap.com/thread/3314916" title="http://scn.sap.com/thread/3314916">http://scn.sap.com/thread/3314916</A></P></BODY></HTML> Wed, 27 Feb 2013 14:28:25 GMT Former Member 2013-02-27T14:28:25Z Excel Attachment Date Column https://community.sap.com/t5/application-development-and-automation-discussions/excel-attachment-date-column/m-p/9307476#M1726901 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I did get a lot of help from SCN posts on how to send an Excel sheet as attachment with email. My email is going fine. Everything is ok.. actually almost every thing ! I have some columns which have dates in them. Right now they are getting displayed as String. The general code is :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l_data <SPAN class="L0S55">= </SPAN>l_xml_document<SPAN class="L0S70">-&gt;</SPAN>create_simple_element<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Data'</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= </SPAN>l_cell_data</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; parent <SPAN class="L0S55">= </SPAN>l_cell <SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; l_data<SPAN class="L0S70">-&gt;</SPAN>set_attribute_ns<SPAN class="L0S55">( </SPAN>name <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'Type'</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prefix <SPAN class="L0S55">= </SPAN><SPAN class="L0S33">'ss'</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="L0S52">value </SPAN><SPAN class="L0S55">= l_type</SPAN><SPAN class="L0S33"> </SPAN><SPAN class="L0S55">)</SPAN><SPAN class="L0S55">.</SPAN></P><P><SPAN class="L0S55"><BR /></SPAN></P><P></P><P></P><P><SPAN class="L0S55"><BR /></SPAN></P><P>I have tried few options:</P><P></P><P>1. </P></BODY></HTML> Tue, 26 Feb 2013 23:06:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-attachment-date-column/m-p/9307476#M1726901 Former Member 2013-02-26T23:06:18Z Re: Excel Attachment Date Column https://community.sap.com/t5/application-development-and-automation-discussions/excel-attachment-date-column/m-p/9307477#M1726902 <HTML><HEAD></HEAD><BODY><P>Duplicate Thread.. closing this one.. original thread is at <A _jive_internal="true" href="https://answers.sap.com/thread/3314916" title="http://scn.sap.com/thread/3314916">http://scn.sap.com/thread/3314916</A></P></BODY></HTML> Wed, 27 Feb 2013 14:28:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-attachment-date-column/m-p/9307477#M1726902 Former Member 2013-02-27T14:28:25Z