Excel Attachment Date Column

[Former Member]

Hi All,

     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 :

       l_data = l_xml_document->create_simple_element( name = 'Data'

                                                   value = l_cell_data

                                                   parent = l_cell ).

         l_data->set_attribute_ns( name = 'Type'

                                       prefix = 'ss'

                                       value = l_type ).

I have tried few options:

1. l_cell = '02/26/2013' , l_type = 'Number'   * This one corrupts the file. I guess becuase of '/' in the string.

2. l_cell = '02/26/2013' , l_type = 'Standard'  * This one corrupts the file. May be Standard is not the right input . But I read it on SCN only.

3. l_cell = '02/26/2013' , l_type = 'DateTime'  * This one corrupts the file. DateTime is valid XML input but not sure what is wrong.

4. l_cell = '02/26/2013' , l_type = 'String' .     * This one created the file but date format is wrong.

For creating the cell I am using Style ID which is generic and has only BORDERS properties only.

Any Pointer?

Thanks

[Former Member]

Any one ? Any ideas !?!