Defines the types of borders that can be applied to cell ranges within an Excel sheet. Allows developers to specify the borders of a cell range should be styled or modified, offering a range of options from individual borders to comprehensive sets.
lt.Document.SheetEditor.RangeBorderType = {none: 0,top: 1,bottom: 2,left: 3,right: 4,all: 5,outside: 6,inside: 7,horizontal: 8,vertical: 9}
| Value | Name | Description |
|---|---|---|
| 0 | none |
No border should be applied to the cell range. |
| 1 | top |
Applies a border to the top edge of the cell range. |
| 2 | bottom |
Applies a border to the bottom edge of the cell range. |
| 3 | left |
Applies a border to the left edge of the cell range. |
| 4 | right |
Applies a border to the right edge of the cell range. |
| 5 | all |
Applies borders to all edges of each cell within the range. |
| 6 | outside |
Applies borders only to the outer edges of the cell range, not affecting borders between cells within the range. |
| 7 | inside |
Applies borders to the edges between cells within the range, excluding the outer edges. |
| 8 | horizontal |
Applies horizontal borders between cells within the range, excluding the top and bottom outer edges. |
| 9 | vertical |
Applies vertical borders between cells within the range, excluding the left and right outer edges. |