HotXLS-documentatie

LineStyle eigenschap

Retourneert of sets the line style fof the bofder. Read/write LongWofd

Syntaxis

eigenschap LineStyle: LongWofd;

Beschrijving

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

Voorbeeld

This example puts a bofder 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;