SAP/ABAP

Excel OLE constants

Denise 2012. 12. 3. 11:38

XlHAlign Enumeration

NameValueDescription
xlHAlignCenter-4108Center.
xlHAlignCenterAcrossSelection7Center across selection.
xlHAlignDistributed-4117Distribute.
xlHAlignFill5Fill.
xlHAlignGeneral1Align according to data type.
xlHAlignJustify-4130Justify.
xlHAlignLeft-4131Left.
xlHAlignRight-4152Right.

http://msdn.microsoft.com/en-us/library/bb241313(v=office.12).aspx

XlVAlign Enumeration

NameValueDescription
xlVAlignBottom-4107Bottom
xlVAlignCenter-4108Center
xlVAlignDistributed-4117Distributed
xlVAlignJustify-4130Justify
xlVAlignTop-4160Top

http://msdn.microsoft.com/en-us/library/office/bb216413(v=office.12).aspx

XlBordersIndex Enumeration

NameValueDescription
xlDiagonalDown5Border running from the upper left-hand corner to the lower right of each cell in the range.
xlDiagonalUp6Border running from the lower left-hand corner to the upper right of each cell in the range.
xlEdgeBottom9Border at the bottom of the range.
xlEdgeLeft7Border at the left-hand edge of the range.
xlEdgeRight10Border at the right-hand edge of the range.
xlEdgeTop8Border at the top of the range.
xlInsideHorizontal12Horizontal borders for all cells in the range except borders on the outside of the range.
xlInsideVertical11Vertical borders for all the cells in the range except borders on the outside of the range.

'SAP > ABAP' 카테고리의 다른 글

MM 단위 환산.  (0) 2013.03.14
Custom Search Help in ALV OOP  (1) 2013.01.23
BAPI_SALESORDER_CHANGE  (0) 2012.09.12
An Easy Reference for ALV Grid Control  (0) 2012.09.06
Excel Dynamic Upload ver. 2.0  (0) 2012.08.28