topic format column using ole. in Application Development and Automation Discussions

format column using ole.

Former Member — Mon, 13 Jul 2009 10:50:41 GMT

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

thanks

Former Member — Mon, 13 Jul 2009 11:11:27 GMT

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 — Mon, 13 Jul 2009 11:14:34 GMT

hi neelambari,

you can use this snippet written by me

cheers

s.janagar

Former Member — Mon, 13 Jul 2009 11:21:33 GMT

Thanks