xlsxSimple-package: xlxs Simple

In But-I-Digress/xlsxSimple: A Simple Interface to the xlsx Package

Description

A simple interface to the xlsx package, simplifying the task of sending a data frame or a graph to Excel.

Details

This requires the xlxs package and the Java run time environment. Which means that it will only run with the version of Java that you have installed and running. You may need to install with one of:

• utils::install.packages(file.choose(), INSTALL_opts="--no-multiarch")

• devtools::install(path, args = "--no-multiarch")

• devtools::install_github("But-I-Digress/xlsxSimple", args = "--no-multiarch")

Changes With This Release

• The “book” parameter has been renamed “workbook” to more closely follow the usage in the xlsx package and has been made optional. When xlsxSimple is loaded a default workbook is created. This workbook is then used wherever the “workbook” parameter is omitted.

• Error trapping has been added for the toSheet method. If there is no defined method for the object that you are trying to send to a sheet then an error is now thrown. Id est, toSheet(NULL).

• saveWorkbook no longer requires “file.path”, “title” or “subject” parameters. If “file.path” is omitted then the workbook will be saved with the same path as the script but with an XLSX extension.

Author(s)

Maintainer: Charles Scheid [e-mail]

References

https://poi.apache.org/apidocs/org/apache/poi/

See Also

xlsx, rJava

Examples

## Not run: 
createWorkbook() -> book
toSheet(book, mtcars, "mtcars") -> sheet
addHyperLinks(sheet, "Google", "http://google.com")
saveWokbook(book, start = TRUE)

library(ggplot2)
(mtcars %>% ggplot(aes(mpg, cyl)) + geom_point()) %>% toSheet
saveWokbook(start = TRUE)

## End(Not run)

But-I-Digress/xlsxSimple documentation built on Jan. 26, 2020, 9:53 a.m.