how to use ABAP to set backcolor of rectangle in Excel template?(DOI tech)

[Former Member]

Hi, does any experts here?

I uploaed an Excel template into SAP. There are three rectangles with white backcolor in it. When the input currency is RMB, the first rectangle should change to black backcolor. And so on.

I use "spreadsheet type ref to i_oi_spreadsheet", but I can't select the rectangle object in the sheet and can't set the color. Can anybody help.

Or can I use Excel macro from ABAP?

Or can OLE can solve this question?

Can anybody give some coding for example?

Thanks you all guys.

[Former Member]

Thanks guys.

I found the solution:

CALL METHOD document->execute_macro

EXPORTING

macro_string = '模块1.Insert'

param1 = '7'

param_count = 1

IMPORTING

error = errors.

CALL METHOD error->raise_message

EXPORTING

type = 'E'.