Excel formatting with if_xml_element (zebra pattern)

former_member699003 — Wed, 30 Jun 2021 13:47:50 GMT

Hi Abappers,

I'm working on a program that converts data in a global table into an xls file and sends mail.

The current excel output is like this.

I used the "if_ixml_element" interface to generate this output.

But the output style I need to do should be like this, with zebra.

This is how I did the blue coloring in the first photo.

  r_format  = l_document->create_simple_element( name = 'Interior' parent = r_style1  ).

  r_format->set_attribute_ns( name = 'Color'   prefix = 'ss'  value = '#ADD8E6' ).

  r_format->set_attribute_ns( name = 'Pattern' prefix = 'ss'  value = 'Solid' ).

I ask for your help,

Kind regards.

Re: Excel formatting with if_xml_element (zebra pattern)

Sandra_Rossi — Wed, 30 Jun 2021 14:14:58 GMT

IF_IXML_ELEMENT is for any kind of XML, not specifically the format XML 2003 for Excel.

Now, about XML 2003, create manually an Excel workbook with all the colors you wish, save it as XML 2003 and open the generated file with notepad, then do your ABAP so that to generate the same XML.

Good luck.

topic Excel formatting with if_xml_element (zebra pattern) in Application Development and Automation Discussions

Excel formatting with if_xml_element (zebra pattern)

Re: Excel formatting with if_xml_element (zebra pattern)