Description Usage Arguments Details Value Author(s) References See Also Examples
This function is a “quick” implementation of reading all of the spreadsheets within an Open Office workbook. It reads each sheet into a data frame and returns these as a list.
1 2 3 |
file |
the name of the |
header |
a logical value indicating whether the first row is a |
simplify |
a logical value which is intended to allow the caller retrieve a data.frame object rather than a list containing one data.frame when there is only one worksheet in the workbook. |
doc |
the parsed XML document containing the content of the work book. This is a parameter to allow caller who are processing other aspects of the workbook to pass the already parsed XML document to this function, perhaps having modified it. |
stringsAsFactors |
a logical value controlling whether variables
in the result data frame are converted to a factors if they are
strings.
This is passed to |
This uses the Rcompression package to access the files within the archive and then
If simplify
is TRUE
and
the workbook contains a single work sheet, a data frame is returned;
otherwise, a list in which each element is a data frame is returned.
Duncan Temple Lang
~put references to the literature/web site here ~
1 2 | f = system.file("sampleData", "Spreadsheet.ods", package = "ROpenOffice")
read.ods(f, FALSE)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.