IXlsBorders
COM interface ( getting help with interfaces )

 

interface IXlsBorders : IDispatch
{
  [id(1),propget] HRESULT Top([out, retval] IXlsBorder** border);
  [id(2),propget] HRESULT Bottom([out, retval] IXlsBorder** border);
  [id(3),propget] HRESULT Left([out, retval] IXlsBorder** border);
  [id(4),propget] HRESULT Right([out, retval] IXlsBorder** border);
  [id(5),propget] HRESULT DiagonalUp([out, retval] IXlsBorder** border);
  [id(6),propget] HRESULT DiagonalDown([out, retval] IXlsBorder** border);
  [id(7), propget] HRESULT MidHorizontal([out, retval] IXlsBorder** border);
  [id(8), propget] HRESULT MidVertical([out, retval] IXlsBorder** border);

  [id(9), propput] HRESULT Style([in]enumBorderStyle style);
  [id(10), propput] HRESULT Color([in]int nRGB);

}

 

HRESULT Top([out, retval] IXlsBorder** border);
retrieves the top border of the cell or merged cells.

HRESULT Bottom([out, retval] IXlsBorder** border);
retrieves the bottom border of the cell or merged cells.

HRESULT Left([out, retval] IXlsBorder** border);
retrieves the left border of the cell or merged cells.

HRESULT Right([out, retval] IXlsBorder** border);
retrieves the right border of the cell or merged cells.

HRESULT DiagonalUp([out, retval] IXlsBorder** border);
retrieves the upper diagonal border of the cell or merged cells.

HRESULT DiagonalDown([out, retval] IXlsBorder** border);
retrieves the down diagonal border of the cell or merged cells.

HRESULT MidHorizontal([out, retval] IXlsBorder** border);
retrieves the horizontal border in the middle of a block. Especially useful when used with ranges. When used with ranges, it allows the definition of styles for that border inside a block of cells.

HRESULT MidVertical([out, retval] IXlsBorder** border);
retrieves the vertical border in the middle of a block. Especially useful when used with ranges. When used with ranges, it allows the definition of styles for that border inside a block of cells.

HRESULT Style([in]enumBorderStyle style);
defines the style of all 4 main borders in a single statement (top, bottom, left and right). Useful to minimize the amount of code.

HRESULT Color([in]int nRGB);
defines the color of all 4 main borders in a single statement (top, bottom, left and right). Useful to minimize the amount of code.