Description Usage Arguments Details Value Author(s) Examples
You can use this function for loading and manipulating any data.frame, data_frame, tbl_df, matrix, table, vector, or DocumentTermMatrix objects into your system-default spreadsheet software (e.g., Excel) in a real time. This function has employed write_xlsx
under the hood.
1 |
x |
An object of class data.frame, matrix, table, vector, or DocumentTermMatrix. |
... |
Any additional arguments available for write_xlsx. |
viewxl
See example below.
Data object opened in a preferable spreadsheet application window which will in turn be called on your R session again.
JooYoung Seo, jooyoung@psu.edu
Soyoung Choi, sxc940@psu.edu
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | if (interactive()) {
library(ezpickr)
data(airquality)
str(airquality)
## View your data object in your spreadsheet software:
viewxl(airquality)
# Then, when necessary, you can modify the opened data
# in the spreadsheet and save it as a new data.
# You can pass a list object to the `view()` function like below:
l <- list(iris = iris, mtcars = mtcars, chickwts = chickwts, quakes = quakes)
viewxl(l)
# Then, each list item will appear in your Excel window sheet by sheet.
}
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.