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
|
% Generated by roxygen2: do not edit by hand
% Please edit documentation in R/gvisTable.R
\name{gvisTable}
\alias{gvisTable}
\title{Google Table Chart with R
\Sexpr{googleChartName <- "table"}
\Sexpr{gvisChartName <- "gvisTable"}}
\usage{
gvisTable(data, options = list(), chartid, formats = NULL)
}
\arguments{
\item{data}{a \code{\link{data.frame}} to be displayed as a table}
\item{options}{list of configuration options, see:
% START DYNAMIC CONTENT
\Sexpr[results=rd]{gsub("CHARTNAME",
googleChartName,
readLines(file.path(".", "inst", "mansections",
"GoogleChartToolsURLConfigOptions.txt")))}
\Sexpr[results=rd]{paste(readLines(file.path(".", "inst",
"mansections", "gvisOptions.txt")))}}
\item{chartid}{character. If missing (default) a random chart id will be
generated based on chart type and \code{\link{tempfile}}}
\item{formats}{named list. If \code{NULL} (default) no specific format will
be used. The named list needs to contain the column names of the data and
the specified format. The format string is a subset of the ICU pattern set.
For instance, {pattern:'#,###\%'} will result in output values "1,000\%",
"750\%", and "50\%" for values 10, 7.5, and 0.5.}
}
\value{
\Sexpr[results=rd]{paste(gvisChartName)} returns list
of \code{\link{class}}
\Sexpr[results=rd]{paste(readLines(file.path(".", "inst",
"mansections", "gvisOutputStructure.txt")))}
}
\description{
The gvisTable function reads a data.frame and creates text output referring
to the Google Visualisation API, which can be included into a web page, or
as a stand-alone page. The actual chart is rendered by the web browser.
}
\details{
A table that can be sorted and paged. Table cells can be formatted using
format strings, or by directly inserting HTML as cell values. Numeric values
are right-aligned; boolean values are displayed as check marks. Users can
select single rows either with the keyboard or the mouse. Users can sort
rows by clicking on column headers. The header row remains fixed as the user
scrolls. The table fires a number of events corresponding to user
interaction.
}
\examples{
## Please note that by default the googleVis plot command
## will open a browser window and requires Flash and Internet
## connection to display the visualisation.
## Table with links to wikipedia (flags)
tbl1 <- gvisTable(Population)
plot(tbl1)
## Table with enabled paging
tbl2 <- gvisTable(Population, options=list(page='enable',
height='automatic',
width='automatic'))
plot(tbl2)
## Table with formating options
tbl3 <- gvisTable(Population, formats=list(Population="#,###"))
Population[['\% of World Population']] <- Population[['\% of World Population']]/100
tbl4 <- gvisTable(Population, formats=list(Population="#,###",
'\% of World Population'='#.#\%'))
plot(tbl4)
}
\references{
Google Chart Tools API:
\Sexpr[results=rd]{gsub("CHARTNAME",
googleChartName,
readLines(file.path(".", "inst", "mansections",
"GoogleChartToolsURL.txt")))}
% END DYNAMIC CONTENT
}
\seealso{
See also \code{\link{print.gvis}}, \code{\link{plot.gvis}} for
printing and plotting methods.
}
\author{
Markus Gesmann \email{markus.gesmann@gmail.com},
Diego de Castillo \email{decastillo@gmail.com}
}
\keyword{iplot}
|
