topic Re: Replace statement is not working in OLE in Application Development and Automation Discussions

Replace statement is not working in OLE

Former Member — Wed, 02 Jul 2008 11:09:01 GMT

I am generating the excel using OLE and in excel i want ot use replace staement for a column . I want to write the code for that . In excel macro i found some code for that and it is mentioned below

Selection.Replace What:="'", Replacement:="", LookAt:=xlPart, _

SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _

ReplaceFormat:=False

I have convert this in ABAP but it is not working Please find the code in abap

CALL METHOD OF gs_cells_temp 'Replace'

EXPORTING

#1 = '1'

#2 = ' 2'

#3 = 2

#4 = 1

#5 = 'False'

#6 = 'False'

#7 = 'False'.

Can anyone help me in this regard.

Re: Replace statement is not working in OLE

Former Member — Mon, 19 Jul 2010 12:47:29 GMT

Closed

Re: Replace statement is not working in OLE

Former Member — Wed, 17 Oct 2012 12:49:36 GMT

Hi Amit,

I am facing the same issue, can you advice?

Thanks in advance,

Hung

Re: Replace statement is not working in OLE

former_member189059 — Tue, 20 Jul 2021 14:58:50 GMT

I know this is a very 'early' reply, but I was searching for the same solution.

Finally managed it myself. The solution could help others as well.

  data: lo_xl_activesheet type ole2_object.
  data: lo_xl_allcells type ole2_object.
  data: lo_xl_activecell type ole2_object.

" lo_xl_activesheet is set to a worksheet using WORKSHEETS

  call method of lo_xl_activesheet 'CELLS' = lo_xl_allcells.
  call method of lo_xl_allcells 'FIND' = lo_xl_activecell
    EXPORTING
       #1 = '<<name_01_01>>'.

  call method of lo_xl_activecell 'REPLACE'
    EXPORTING
       #1 = '<<name_01_01>>'
       #2 = 'NewValue'.