format column using ole.

[Former Member]

I want to format cell column to type 'Text' using OLE.

thanks

[Former Member]

Hi Neelambari,

use this code snippet.

data : l_gs_excel TYPE ole2_object,

l_gs_cells TYPE ole2_object.

CREATE OBJECT l_gs_excel 'EXCEL.APPLICATION'.

CALL METHOD OF l_gs_excel 'Range' = l_gs_cells

EXPORTING

#1 = 'A1'.

CALL METHOD OF l_gs_cells 'Select' .

SET PROPERTY OF l_gs_cells 'NumberFormat' = '@'.

Amitava

[Former Member]

Hi Neelambari,

use this code snippet.

data : l_gs_excel TYPE ole2_object,

l_gs_cells TYPE ole2_object.

CREATE OBJECT l_gs_excel 'EXCEL.APPLICATION'.

CALL METHOD OF l_gs_excel 'Range' = l_gs_cells

EXPORTING

#1 = 'A1'.

CALL METHOD OF l_gs_cells 'Select' .

SET PROPERTY OF l_gs_cells 'NumberFormat' = '@'.

Amitava

[Former Member]

hi neelambari,

you can use this snippet written by me

https://wiki.sdn.sap.com/wiki/display/Snippets/OLEprogramforconvertingtomultitabexcel

cheers

s.janagar

[Former Member]

Thanks