topic OLE2_OBJECT in Application Development and Automation Discussions

OLE2_OBJECT

Former Member — Wed, 12 Apr 2006 15:33:28 GMT

Hi,

I have used the OLE Object ole2_object

as an include to create an excell file.

I can successfully download the data,

But need all the rows and columns to be left aligned,

Not sure which property to set.

Please help.

Thanks and Regards

Lalitha

Former Member — Wed, 12 Apr 2006 16:02:11 GMT

constants: xlCenter type i value '-4108',

xlBottom type i value '-4107',

xlLeft type i value '-4131',

xlRight type i value '-4152'.

CALL METHOD OF hExcel 'COLUMNS' = hColumn

EXPORTING #1 = p_ColNum . "column number

SET PROPERTY OF hColumn 'HorizontalAlignment' = xlLeft.

Don't forget those points.

Former Member — Wed, 12 Apr 2006 17:02:19 GMT

Hi John,

Thank you,

This solved the problem

Appreciate it

Lalitha