OLE using CL_IXML Class.

[raghavendrareddy]

Hi Experts,

I'm new to working with OLE using the class. Client is requesting a modification in a program implemented using the class CL_IXML. The program displays output in ALV, if the user clicks on a button in the ALV tool bar a mail is triggered with the ALV output as an attachment in excel format.

The code is similar to the one found in the following link:

Formatted Excel as Email Attachment - Code Gallery - SCN Wiki

Now i was asked to include two more rows into the existing excel, like

I have searched in SCN on how to merge two cells using OLE. I got many results like the following link:

But this is not using the class CL_IXML.\

Please suggest how to merge cells using the class CL_IXML.

Thanks in advance

[raghavendrareddy]

Quote about the terms: this thread in the code gallery is not OLE, it's a XMLSS document (Excel 2003 format) built via iXML.

I prefer to tell you the method: create the Excel document as you wish, save it as Excel 2003 format, and open it using Notepad and locate "company LIMITED" and see how it is formatted. Then reproduce the logic via iXML.

[Sandra_Rossi]

Quote about the terms: this thread in the code gallery is not OLE, it's a XMLSS document (Excel 2003 format) built via iXML.

I prefer to tell you the method: create the Excel document as you wish, save it as Excel 2003 format, and open it using Notepad and locate "company LIMITED" and see how it is formatted. Then reproduce the logic via iXML.