OLE2_OBJECT

[Former Member]

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]

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]

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]

Hi John,

Thank you,

This solved the problem

Appreciate it

Lalitha