Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 07, 2009 at 08:48 AM

    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'.

    Add comment
    10|10000 characters needed characters exceeded