About Excel Cell's Bottom line via OLE

[Former Member]

Hi Experts,

I want to set the bottom line (Border for cell but ony with bottom line) to a cell in Excel via OLE.Now I have known the following codes,How would I continue?

CALL METHOD OF sheet 'Range' = range

EXPORTING #1 = 'A5:M5'.

CALL METHOD OF range 'BORDERS' = border.

SET PROPERTY OF border1 'WEIGHT' = 2.

SET PROPERTY OF border1 'ColorIndex' = '3'

About the lineStyle,I just want the bottom line,not a full border.

[Former Member · Accepted solution]

Try,

• bottom

call method of cell 'BORDERS' = borders exporting #1 = '4'.

set property of borders 'LineStyle' = '8'.

set property of borders 'WEIGHT' = we.

• set property of borders 'ColorIndex' = 'xlAutomatic'.

free object borders.

left #1 = 1

right #1 = 2

top #1 = 3.

Regards

J

[Former Member · Accepted solution]

Thanks so much

You have given me such a tremendous help.

It is so lucky to meet with such a excellent SAP guy.