Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
Spreadsheet
EmbeddedTableChartBuilder
Interface EmbeddedTableChartBuilder
Builder for table charts. For more details, see the Gviz documentation.
interface
EmbeddedTableChartBuilder
{
addRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
,
)
:
EmbeddedChartBuilder
;
asAreaChart
()
:
EmbeddedAreaChartBuilder
;
asBarChart
()
:
EmbeddedBarChartBuilder
;
asColumnChart
()
:
EmbeddedColumnChartBuilder
;
asComboChart
()
:
EmbeddedComboChartBuilder
;
asHistogramChart
()
:
EmbeddedHistogramChartBuilder
;
asLineChart
()
:
EmbeddedLineChartBuilder
;
asPieChart
()
:
EmbeddedPieChartBuilder
;
asScatterChart
()
:
EmbeddedScatterChartBuilder
;
asTableChart
()
:
EmbeddedTableChartBuilder
;
build
()
:
GoogleAppsScript
.
Spreadsheet
.
EmbeddedChart
;
clearRanges
()
:
EmbeddedChartBuilder
;
enablePaging
(
enablePaging
:
boolean
)
:
EmbeddedTableChartBuilder
;
enablePaging
(
pageSize
:
number
)
:
EmbeddedTableChartBuilder
;
enablePaging
(
pageSize
:
number
,
startPage
:
number
,
)
:
EmbeddedTableChartBuilder
;
enableRtlTable
(
rtlEnabled
:
boolean
)
:
EmbeddedTableChartBuilder
;
enableSorting
(
enableSorting
:
boolean
)
:
EmbeddedTableChartBuilder
;
getChartType
()
:
ChartType
;
getContainer
()
:
ContainerInfo
;
getRanges
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
[]
;
removeRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
,
)
:
EmbeddedChartBuilder
;
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
;
setFirstRowNumber
(
number
:
number
)
:
EmbeddedTableChartBuilder
;
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
;
setInitialSortingAscending
(
column
:
number
)
:
EmbeddedTableChartBuilder
;
setInitialSortingDescending
(
column
:
number
)
:
EmbeddedTableChartBuilder
;
setMergeStrategy
(
mergeStrategy
:
ChartMergeStrategy
)
:
EmbeddedChartBuilder
;
setNumHeaders
(
headers
:
number
)
:
EmbeddedChartBuilder
;
setOption
(
option
:
string
,
value
:
any
)
:
EmbeddedChartBuilder
;
setPosition
(
anchorRowPos
:
number
,
anchorColPos
:
number
,
offsetX
:
number
,
offsetY
:
number
,
)
:
EmbeddedChartBuilder
;
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
;
showRowNumberColumn
(
showRowNumber
:
boolean
)
:
EmbeddedTableChartBuilder
;
useAlternatingRowStyle
(
alternate
:
boolean
)
:
EmbeddedTableChartBuilder
;
}
Index
Methods
add
Range
as
Area
Chart
as
Bar
Chart
as
Column
Chart
as
Combo
Chart
as
Histogram
Chart
as
Line
Chart
as
Pie
Chart
as
Scatter
Chart
as
Table
Chart
build
clear
Ranges
enable
Paging
enable
Rtl
Table
enable
Sorting
get
Chart
Type
get
Container
get
Ranges
remove
Range
set
Chart
Type
set
First
Row
Number
set
Hidden
Dimension
Strategy
set
Initial
Sorting
Ascending
set
Initial
Sorting
Descending
set
Merge
Strategy
set
Num
Headers
set
Option
set
Position
set
Transpose
Rows
And
Columns
show
Row
Number
Column
use
Alternating
Row
Style
Methods
add
Range
addRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
)
:
EmbeddedChartBuilder
Parameters
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
EmbeddedChartBuilder
as
Area
Chart
asAreaChart
()
:
EmbeddedAreaChartBuilder
Returns
EmbeddedAreaChartBuilder
as
Bar
Chart
asBarChart
()
:
EmbeddedBarChartBuilder
Returns
EmbeddedBarChartBuilder
as
Column
Chart
asColumnChart
()
:
EmbeddedColumnChartBuilder
Returns
EmbeddedColumnChartBuilder
as
Combo
Chart
asComboChart
()
:
EmbeddedComboChartBuilder
Returns
EmbeddedComboChartBuilder
as
Histogram
Chart
asHistogramChart
()
:
EmbeddedHistogramChartBuilder
Returns
EmbeddedHistogramChartBuilder
as
Line
Chart
asLineChart
()
:
EmbeddedLineChartBuilder
Returns
EmbeddedLineChartBuilder
as
Pie
Chart
asPieChart
()
:
EmbeddedPieChartBuilder
Returns
EmbeddedPieChartBuilder
as
Scatter
Chart
asScatterChart
()
:
EmbeddedScatterChartBuilder
Returns
EmbeddedScatterChartBuilder
as
Table
Chart
asTableChart
()
:
EmbeddedTableChartBuilder
Returns
EmbeddedTableChartBuilder
build
build
()
:
GoogleAppsScript
.
Spreadsheet
.
EmbeddedChart
Returns
GoogleAppsScript
.
Spreadsheet
.
EmbeddedChart
clear
Ranges
clearRanges
()
:
EmbeddedChartBuilder
Returns
EmbeddedChartBuilder
enable
Paging
enablePaging
(
enablePaging
:
boolean
)
:
EmbeddedTableChartBuilder
Parameters
enablePaging
:
boolean
Returns
EmbeddedTableChartBuilder
enablePaging
(
pageSize
:
number
)
:
EmbeddedTableChartBuilder
Parameters
pageSize
:
number
Returns
EmbeddedTableChartBuilder
enablePaging
(
pageSize
:
number
,
startPage
:
number
)
:
EmbeddedTableChartBuilder
Parameters
pageSize
:
number
startPage
:
number
Returns
EmbeddedTableChartBuilder
enable
Rtl
Table
enableRtlTable
(
rtlEnabled
:
boolean
)
:
EmbeddedTableChartBuilder
Parameters
rtlEnabled
:
boolean
Returns
EmbeddedTableChartBuilder
enable
Sorting
enableSorting
(
enableSorting
:
boolean
)
:
EmbeddedTableChartBuilder
Parameters
enableSorting
:
boolean
Returns
EmbeddedTableChartBuilder
get
Chart
Type
getChartType
()
:
ChartType
Returns
ChartType
get
Container
getContainer
()
:
ContainerInfo
Returns
ContainerInfo
get
Ranges
getRanges
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
[]
Returns
GoogleAppsScript
.
Spreadsheet
.
Range
[]
remove
Range
removeRange
(
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
)
:
EmbeddedChartBuilder
Parameters
range
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
EmbeddedChartBuilder
set
Chart
Type
setChartType
(
type
:
ChartType
)
:
EmbeddedChartBuilder
Parameters
type
:
ChartType
Returns
EmbeddedChartBuilder
set
First
Row
Number
setFirstRowNumber
(
number
:
number
)
:
EmbeddedTableChartBuilder
Parameters
number
:
number
Returns
EmbeddedTableChartBuilder
set
Hidden
Dimension
Strategy
setHiddenDimensionStrategy
(
strategy
:
ChartHiddenDimensionStrategy
,
)
:
EmbeddedChartBuilder
Parameters
strategy
:
ChartHiddenDimensionStrategy
Returns
EmbeddedChartBuilder
set
Initial
Sorting
Ascending
setInitialSortingAscending
(
column
:
number
)
:
EmbeddedTableChartBuilder
Parameters
column
:
number
Returns
EmbeddedTableChartBuilder
set
Initial
Sorting
Descending
setInitialSortingDescending
(
column
:
number
)
:
EmbeddedTableChartBuilder
Parameters
column
:
number
Returns
EmbeddedTableChartBuilder
set
Merge
Strategy
setMergeStrategy
(
mergeStrategy
:
ChartMergeStrategy
)
:
EmbeddedChartBuilder
Parameters
mergeStrategy
:
ChartMergeStrategy
Returns
EmbeddedChartBuilder
set
Num
Headers
setNumHeaders
(
headers
:
number
)
:
EmbeddedChartBuilder
Parameters
headers
:
number
Returns
EmbeddedChartBuilder
set
Option
setOption
(
option
:
string
,
value
:
any
)
:
EmbeddedChartBuilder
Parameters
option
:
string
value
:
any
Returns
EmbeddedChartBuilder
set
Position
setPosition
(
anchorRowPos
:
number
,
anchorColPos
:
number
,
offsetX
:
number
,
offsetY
:
number
,
)
:
EmbeddedChartBuilder
Parameters
anchorRowPos
:
number
anchorColPos
:
number
offsetX
:
number
offsetY
:
number
Returns
EmbeddedChartBuilder
set
Transpose
Rows
And
Columns
setTransposeRowsAndColumns
(
transpose
:
boolean
)
:
EmbeddedChartBuilder
Parameters
transpose
:
boolean
Returns
EmbeddedChartBuilder
show
Row
Number
Column
showRowNumberColumn
(
showRowNumber
:
boolean
)
:
EmbeddedTableChartBuilder
Parameters
showRowNumber
:
boolean
Returns
EmbeddedTableChartBuilder
use
Alternating
Row
Style
useAlternatingRowStyle
(
alternate
:
boolean
)
:
EmbeddedTableChartBuilder
Parameters
alternate
:
boolean
Returns
EmbeddedTableChartBuilder
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Methods
add
Range
as
Area
Chart
as
Bar
Chart
as
Column
Chart
as
Combo
Chart
as
Histogram
Chart
as
Line
Chart
as
Pie
Chart
as
Scatter
Chart
as
Table
Chart
build
clear
Ranges
enable
Paging
enable
Rtl
Table
enable
Sorting
get
Chart
Type
get
Container
get
Ranges
remove
Range
set
Chart
Type
set
First
Row
Number
set
Hidden
Dimension
Strategy
set
Initial
Sorting
Ascending
set
Initial
Sorting
Descending
set
Merge
Strategy
set
Num
Headers
set
Option
set
Position
set
Transpose
Rows
And
Columns
show
Row
Number
Column
use
Alternating
Row
Style
Google Apps Script API
Loading...
Builder for table charts. For more details, see the Gviz documentation.