Usage
getWorksheets(doc, con = getGoogleDocsConnection(service = "wise"), stringsAsFactors = default.stringsAsFactors())
sheetAsMatrix(sheet, header = FALSE, as.data.frame = TRUE, trim = TRUE, con = sheet@connection, doc = xmlParse(getCells(sheet, con = con)), stringsAsFactors = default.stringsAsFactors())
Arguments
doc
the name of the spreadsheet document or a GoogleDocument
object
obtained via a call to getDocs
.
In sheetAsMatrix
this is the parsed XML document containing
the cell values. This is typically computed via the
default value of the parameter. But one can call getCells
separately with non-default values for the parameters.
con
the authenticated connection to the Google Spreadsheets API.
This must be for the "wise" service rather than the general "writely" service.
So this should be an object of class "GoogleSpreadsheetsConnection"
created with a call of the form getGoogleDocsConnection(login, password, "wise")
.
sheet
the sheet object of class GoogleWorksheetRef
.
header
information about the column headers for the worksheet.
This is a) a character vector giving the names of the resulting columns (after the empty columns have been
discarded), b) a logical value of TRUE
indicating whether the first row of the worksheet is to be treated
as the header, and c) a logical value of FALSE
indicating that there are no column headers available
and so use V1, V2, ...
as.data.frame
a logical value indicating whether a matrix (FALSE
) or a data frame (TRUE
)
is to be created
trim
a logical value indicating whether to drop the rows and columns of the worksheet that have only
missing values, i.e. those that may be used for pseudo-formatting/layout.
This is optional as there may be rows or columns that contain legitmate missing values.
The algorithm for converting the cells to a table could be more intelligent about this
and explicitly determine the rows and columns which have no
values, not which contain NA
s.
stringsAsFactors
a logical indicating whether to convert string
variables to factors (TRUE
), or leave as character
vectors (FALSE
).