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. |