topic Re: Declare Array in OLE Excel in Application Development and Automation Discussions

Declare Array in OLE Excel

Former Member — Thu, 11 Mar 2010 04:14:41 GMT

Dear all,

How can I declare a variable type Array in Excel Ole ABAP ??

Dim a As Variant

a = Array(11, 12)

How can I declare in ABAP ??

Thank you

Former Member — Wed, 01 Sep 2010 10:07:06 GMT

Note 633105 - OLE automation: ABAP type for OLE array parameters

Symptom

If the method of an OLE object contains an array parameter, there is no suitable ABAP data type for the parameter.

Reason and Prerequisites

Array is not supported as a data type for OLE parameters in ABAP.

Solution

None

Pawan_Kesari — Wed, 01 Sep 2010 10:15:27 GMT

Arrays can be represented in ABAP by internal tables with some effort.

Whether you can pass internal table to OLE method with an array as parameter is different story though.

Regards,

Pawan.

mauro_calenda — Mon, 08 Jun 2020 07:04:34 GMT

Hi everybody, I'm facing today this issue and I wonder if this limitation has been overcome. Any tips would be appreciated. CalMa