Nika-Soft logo Nika-Soft logo
   Products   |   Download   |   Order   |   Forum   |   Contact us   

NativeExcel suite v1.x

Reference > IXLSBorder > LineStyle

LineStyle property

Returns or sets the line style for the border. Read/write LongWord.

Syntax

property LineStyle: LongWord;

Description

LineStyle can be one of these XlLineStyle constants.
xlContinuous
xlDash
xlDashDot
xlDashDotDot
xlDot
xlDouble
xlSlantDashDot
xlLineStyleNone

Example

This example puts a border around the A1:C5 range. 
Workbook.Sheets[1].Range['A1', 'C5'].Borders[xlEdgeTop].LineStyle := xlDot;
Workbook.Sheets[1].Range['A1', 'C5'].Borders[xlEdgeRight].LineStyle := xlDot;
Workbook.Sheets[1].Range['A1', 'C5'].Borders[xlEdgeBottom].LineStyle := xlDot;
Workbook.Sheets[1].Range['A1', 'C5'].Borders[xlEdgeLeft].LineStyle := xlDot;
This example is the same to previous. 
Workbook.Sheets[1].Range['A1', 'C5'].Borders.LineStyle := xlDot;
Copyright © NikaSoft 2004-2010