on 01-07-2009 7:31 AM
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.
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'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.