topic Re: add table using ole in Application Development and Automation Discussions

add table using ole

Former Member — Thu, 09 Jul 2009 14:17:59 GMT

Hello,

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

Thanks,

Regards,

Neelambari

former_member229729 — Thu, 09 Jul 2009 14:28:49 GMT

Hello,

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

Hope your query get solved.

Thanks and regards,

Ramani N

Former Member — Thu, 09 Jul 2009 14:48:05 GMT

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 — Fri, 10 Jul 2009 07:25:37 GMT

Thanks