add table using ole

[Former Member]

Hello,

How to add table and border using ole in excel sheet?

Thanks,

Regards,

Neelambari

[former_member229729]

Hello,

There is a Complete & Very good documentation by SAP available on this URL. Please read this.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/204d1bb8-489d-2910-d0b5-cdddb322...

Hope your query get solved.

Thanks and regards,

Ramani N

[Former Member]

Hi Neelambari,

U need to select the required cells using .....

CALL METHOD OF p_gs_excel 'Range' = l_gs_s_cells
    EXPORTING
    #1 = p_sel_cells.
  CALL METHOD OF l_gs_s_cells 'Select' .

here p_sel_cells. equals to A1:A1,A2:C2,A7:A7,A8:H8,A13:A13.

or u can give A1:C3.

Now drawing the box.....

DATA: l_gs_borders TYPE ole2_object.
GET PROPERTY OF l_gs_s_cells 'Borders' = l_gs_borders.
SET PROPERTY OF l_gs_borders 'LineStyle' = 1.

u can change the value 1 to other value for drawing different kind of box....

Amitava

[Former Member]

Thanks