Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

OLE2_OBJECT

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

Tags:
Former Member
Former Member replied

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.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question