The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.
library(tablexlsx)
library(dplyr, warn.conflicts = FALSE)
#> Warning: le package 'dplyr' a été compilé avec la version R 4.1.3
Let’s define an export folder that will be the same for all the examples on this page
<- tempdir() mypath
Important : in this vignette, all examples use
%>%
to pass theobject
argument in thetoxlsx()
function, but it works interchangeably with these 3 syntaxes below :
toxlsx(object = iris, path = mypath)
|> toxlsx(path = mypath)
iris %>% toxlsx(path = mypath) iris
%>% toxlsx(path = mypath) iris
Preview of the xlsx file in LibreOffice Calc :
list(iris,cars) %>% toxlsx(path = mypath)
Preview of the xlsx file in LibreOffice Calc :
# Create df1
<- data.frame(
df1 group = c("dupont","dupont","arnold","arnold"),
name = c("toto","tata","tutu","tete"),
volume = c(10,8,12,15)
)# Export
%>% toxlsx(path = mypath, mergecol = "group") df1
Preview of the xlsx file in LibreOffice Calc :
# Create df2
<- data.frame(
df2 country = c(rep("france",4),rep("england",4)),
group = c(rep("dupont",2),rep("martin",2),
rep("arnold",2),rep("harry",2)),
name = c("toto","tata","tutu","tete",
"momo","mama","mumu","meme"),
volume = c(10,8,12,15,
14,10,5,12)
)# Export
%>% toxlsx(path = mypath, mergecol = c("country","group")) df2
Preview of the xlsx file in LibreOffice Calc :
<- data.frame(tables = c(rep("iris",5),rep("cars",2)),
tb1 var = c(names(iris),names(cars)))
<- data.frame(tables = c("iris","cars","cars"),
tb2 rownumber = c(150,50,32))
list(tb1,tb2) %>%
toxlsx(tosheet = list("tb1" = "mydata",
"tb2" = "mydata"),
footnote1 = list("tb1" = "The data set contains 3 classes of 50 instances each, where each class refers to a type of iris plant.",
"tb2" = "The data give the speed of cars and the distances taken to stop. Note that the data were recorded in the 1920s."),
footnote2 = list("tb1" = "Predicted attribute: class of iris plant.",
"tb2" = "Data recorded in the 1920s"),
footnote3 = list("tb1" = "Source : R.A. Fisher",
"tb2" = "Source : M. Ezekiel"),
path=mypath)
Preview of the xlsx file in LibreOffice Calc :
<- iris %>% head()
iris <- cars %>% head()
cars
list(iris,cars) %>%
toxlsx(tosheet = list("iris" = "first",
"cars" = "second"),
title = list("iris" = "Head of iris",
"cars" = "Head of cars"),
# The `columnstyle` argument is optional in toxlsx().
# It is used only if you want to specify the format of each column
columnstyle = list("iris" = list("c1" = "decimal",
"c2" = "decimal",
"c3" = "number",
"c4" = "number",
"c5" = "character"),
"cars" = list("c1" = "number",
"c2" = "number")),
footnote1 = list("iris" = "The data set contains 3 classes of 50 instances each, where each class refers to a type of iris plant.",
"cars" = "The data give the speed of cars and the distances taken to stop. Note that the data were recorded in the 1920s."),
footnote2 = list("iris" = "Predicted attribute: class of iris plant.",
"cars" = "Data recorded in the 1920s"),
footnote3 = list("iris" = "Source : R.A. Fisher",
"cars" = "Source : M. Ezekiel"),
filename = "Results",
path = mypath)
The equivalent with the {openxlsx} syntax would be much longer and more painful to write. See here for the equivalent of the sixth example.
Preview of the xlsx file in LibreOffice Calc :
These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.