Service
|
Details
|
Add cell fmt cond |
Add cell format condition.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Format |
Condition format |
2 |
Value |
Condition value |
3 |
Define font color |
Define font color |
4 |
Font R |
R color channel (0-255) |
5 |
Font G |
G color channel (0-255) |
6 |
Font B |
B color channel (0-255) |
7 |
Define border color |
Define border color |
8 |
Border R |
R color channel (0-255) |
9 |
Border G |
G color channel (0-255) |
10 |
Border B |
B color channel (0-255) |
11 |
Define interior color |
Define interior color |
12 |
Interior R |
R color channel (0-255) |
13 |
Interior G |
G color channel (0-255) |
14 |
Interior B |
B color channel (0-255) |
Output |
0 |
Index |
Format condition index |
Add cur rng fmt cond |
Add current range format condition. The service affects the current cell range
as set by the Set cur rng
service.
|
Argument |
Description |
Input |
0 |
Format |
Condition format |
1 |
Value |
Condition value |
2 |
Define font color |
Define font color |
3 |
Font R |
R color channel (0-255) |
4 |
Font G |
G color channel (0-255) |
5 |
Font B |
B color channel (0-255) |
6 |
Define border color |
Define border color |
7 |
Border R |
R color channel (0-255) |
8 |
Border G |
G color channel (0-255) |
9 |
Border B |
B color channel (0-255) |
10 |
Define interior color |
Define interior color |
11 |
Interior R |
R color channel (0-255) |
12 |
Interior G |
G color channel (0-255) |
13 |
Interior B |
B color channel (0-255) |
Output |
0 |
Index |
Format condition index |
Add rng fmt cond |
Add range format condition.
|
Argument |
Description |
Input |
0 |
Start cell coord |
Starting cell coordinate, e.g. A1 |
1 |
End cell coord |
Ending cell coordinate, e.g. B5 |
2 |
Format |
Condition format |
3 |
Value |
Condition value |
4 |
Define font color |
Define font color |
5 |
Font R |
R color channel (0-255) |
6 |
Font G |
G color channel (0-255) |
7 |
Font B |
B color channel (0-255) |
8 |
Define border color |
Define border color |
9 |
Border R |
R color channel (0-255) |
10 |
Border G |
G color channel (0-255) |
11 |
Border B |
B color channel (0-255) |
12 |
Define interior color |
Define interior color |
13 |
Interior R |
R color channel (0-255) |
14 |
Interior G |
G color channel (0-255) |
15 |
Interior B |
B color channel (0-255) |
Output |
0 |
Index |
Format condition index |
Add sheet |
Add a new spreadsheet.
|
Argument |
Description |
Input |
0 |
Sheet name |
Sheet name |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Close |
Close the Excel file.
|
Argument |
Description |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Create |
Create a new instance of Excel.
|
Argument |
Description |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Delete sheet |
Delete a spreadsheet.
|
Argument |
Description |
Input |
0 |
Sheet name |
Sheet name |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Get cell date |
Get cell date value.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
Output |
0 |
Value |
Cell value |
Get cell type |
Get cell value type.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
Output |
0 |
Value type |
Type to use to retrieve cell value |
Get cell value |
Get cell value.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Value type |
Type to use to retrieve cell value |
Output |
0 |
Value |
Cell value |
Merge cur rng |
Merge current range. The service affects the current cell range
as set by the Set cur rng
service.
|
Argument |
Description |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Merge rng |
Merge range.
|
Argument |
Description |
Input |
0 |
Start cell coord |
Starting cell coordinate, e.g. A1 |
1 |
End cell coord |
Ending cell coordinate, e.g. B5 |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Num sheets |
Get number of spreadsheets.
|
Argument |
Description |
Output |
0 |
Num sheets |
Number of sheets |
Open |
Open an existing Excel file.
|
Argument |
Description |
Input |
0 |
Path |
Path to existing Excel file |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Page setup |
Open print page setup.
|
Argument |
Description |
Input |
0 |
Orientation |
Page orientation |
1 |
Print gridlines |
Show gridlines on print |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Rename sheet |
Rename a spreadsheet.
|
Argument |
Description |
Input |
0 |
Sheet name |
Sheet name |
1 |
New sheet name |
New sheet name |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Save as |
Save Excel file.
|
Argument |
Description |
Input |
0 |
Path |
Save path for Excel file |
1 |
Overwrite |
Overwrite exsiting file |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Select sheet |
Select a spreadsheet.
|
Argument |
Description |
Input |
0 |
Sheet name |
Sheet name |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Set cell brd |
Set cell border.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Border |
Border type |
2 |
Line style |
Border line style |
3 |
Width |
Border width |
4 |
R |
R color channel (0-255) |
5 |
G |
G color channel (0-255) |
6 |
B |
B color channel (0-255) |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Set cell col wd |
Set cell column width.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Width |
Column width |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Set cell fmt cond brd |
Set cell format condition border.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Index |
Format condition index |
2 |
Border |
Border type |
3 |
Line style |
Border line style |
4 |
Width |
Border width |
5 |
R |
R color channel (0-255) |
6 |
G |
G color channel (0-255) |
7 |
B |
B color channel (0-255) |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Set cell fmt cond font |
Set cell format condition font.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Index |
Format condition index |
2 |
Font name |
Font family name |
3 |
Font size |
Font size |
4 |
R |
R color channel (0-255) |
5 |
G |
G color channel (0-255) |
6 |
B |
B color channel (0-255) |
7 |
Italic |
Italic |
8 |
Bold |
Bold |
9 |
Strikethrough |
Strikethrough |
10 |
Underline |
Underline |
11 |
Subscript |
Subscript |
12 |
Superscript |
Superscript |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Set cell fmt cond int |
Set cell format condition interior.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Index |
Format condition index |
2 |
Pattern |
Interior cell pattern |
3 |
R |
R color channel (0-255) |
4 |
G |
G color channel (0-255) |
5 |
B |
B color channel (0-255) |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |
Set cell font |
Set cell font.
|
Argument |
Description |
Input |
0 |
Cell coord |
Cell coordinate, e.g. A1 |
1 |
Font name |
Font family name |
2 |
Font size |
Font size |
3 |
R |
R color channel (0-255) |
4 |
G |
G color channel (0-255) |
5 |
B |
B color channel (0-255) |
6 |
Italic |
Italic |
7 |
Bold |
Bold |
8 |
Strikethrough |
Strikethrough |
9 |
Underline |
Underline |
10 |
Subscript |
Subscript |
11 |
Superscript |
Superscript |
Output |
0 |
Succeeded |
Operation succeeded: TRUE or FALSE |