HotXLS Docs

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;