-
Notifications
You must be signed in to change notification settings - Fork 61
/
excel.interfaces.tableupdatedata.yml
133 lines (131 loc) · 5.16 KB
/
excel.interfaces.tableupdatedata.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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
### YamlMime:TSType
name: Excel.Interfaces.TableUpdateData
uid: 'excel!Excel.Interfaces.TableUpdateData:interface'
package: excel!
fullName: Excel.Interfaces.TableUpdateData
summary: 'An interface for updating data on the Table object, for use in `table.set({ ... })`<!-- -->.'
remarks: ''
isPreview: false
isDeprecated: false
type: interface
properties:
- name: highlightFirstColumn
uid: 'excel!Excel.Interfaces.TableUpdateData#highlightFirstColumn:member'
package: excel!
fullName: highlightFirstColumn
summary: Specifies if the first column contains special formatting.
remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'highlightFirstColumn?: boolean;'
return:
type: boolean
- name: highlightLastColumn
uid: 'excel!Excel.Interfaces.TableUpdateData#highlightLastColumn:member'
package: excel!
fullName: highlightLastColumn
summary: Specifies if the last column contains special formatting.
remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'highlightLastColumn?: boolean;'
return:
type: boolean
- name: name
uid: 'excel!Excel.Interfaces.TableUpdateData#name:member'
package: excel!
fullName: name
summary: >-
Name of the table.
The set name of the table must follow the guidelines specified in the [Rename an Excel
table](https://support.microsoft.com/office/fbf49a4f-82a3-43eb-8ba2-44d21233b114) article.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'name?: string;'
return:
type: string
- name: showBandedColumns
uid: 'excel!Excel.Interfaces.TableUpdateData#showBandedColumns:member'
package: excel!
fullName: showBandedColumns
summary: >-
Specifies if the columns show banded formatting in which odd columns are highlighted differently from even ones,
to make reading the table easier.
remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showBandedColumns?: boolean;'
return:
type: boolean
- name: showBandedRows
uid: 'excel!Excel.Interfaces.TableUpdateData#showBandedRows:member'
package: excel!
fullName: showBandedRows
summary: >-
Specifies if the rows show banded formatting in which odd rows are highlighted differently from even ones, to make
reading the table easier.
remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showBandedRows?: boolean;'
return:
type: boolean
- name: showFilterButton
uid: 'excel!Excel.Interfaces.TableUpdateData#showFilterButton:member'
package: excel!
fullName: showFilterButton
summary: >-
Specifies if the filter buttons are visible at the top of each column header. Setting this is only allowed if the
table contains a header row.
remarks: '\[ [API set: ExcelApi 1.3](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showFilterButton?: boolean;'
return:
type: boolean
- name: showHeaders
uid: 'excel!Excel.Interfaces.TableUpdateData#showHeaders:member'
package: excel!
fullName: showHeaders
summary: Specifies if the header row is visible. This value can be set to show or remove the header row.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showHeaders?: boolean;'
return:
type: boolean
- name: showTotals
uid: 'excel!Excel.Interfaces.TableUpdateData#showTotals:member'
package: excel!
fullName: showTotals
summary: Specifies if the total row is visible. This value can be set to show or remove the total row.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'showTotals?: boolean;'
return:
type: boolean
- name: style
uid: 'excel!Excel.Interfaces.TableUpdateData#style:member'
package: excel!
fullName: style
summary: >-
Constant value that represents the table style. Possible values are: "TableStyleLight1" through
"TableStyleLight21", "TableStyleMedium1" through "TableStyleMedium28", "TableStyleDark1" through
"TableStyleDark11". A custom user-defined style present in the workbook can also be specified.
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
syntax:
content: 'style?: string;'
return:
type: string