Excel Attachment Date Column

Former Member — Tue, 26 Feb 2013 23:12:02 GMT

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

Re: Excel Attachment Date Column

Former Member — Thu, 28 Feb 2013 16:28:08 GMT

Any one ? Any ideas !?!

topic Re: Excel Attachment Date Column in Application Development and Automation Discussions

Excel Attachment Date Column

Re: Excel Attachment Date Column