/
excelscript.connectortype.yml
47 lines (42 loc) · 1.22 KB
/
excelscript.connectortype.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
### YamlMime:TSEnum
name: ExcelScript.ConnectorType
uid: 'ExcelScript!ExcelScript.ConnectorType:enum'
package: ExcelScript!
fullName: ExcelScript.ConnectorType
summary: ''
remarks: |-
#### Examples
```TypeScript
/**
* This script adds a line that goes from cell B2 to cell F4 on the current worksheet.
*/
function main(workbook: ExcelScript.Workbook) {
// Get the current worksheet.
const sheet = workbook.getActiveWorksheet();
// Get the ranges for the two cells.
const b2Range = sheet.getRange("B2");
const f4Range = sheet.getRange("F4");
// Add a straight line that connects the top-left corners of both cells.
const line = sheet.addLine(
b2Range.getLeft(),
b2Range.getTop(),
f4Range.getLeft(),
f4Range.getTop(),
ExcelScript.ConnectorType.straight);
}
```
isPreview: false
isDeprecated: false
fields:
- name: curve
uid: 'ExcelScript!ExcelScript.ConnectorType.curve:member'
package: ExcelScript!
summary: ''
- name: elbow
uid: 'ExcelScript!ExcelScript.ConnectorType.elbow:member'
package: ExcelScript!
summary: ''
- name: straight
uid: 'ExcelScript!ExcelScript.ConnectorType.straight:member'
package: ExcelScript!
summary: ''