Learn R Programming

ImportExport (version 1.3)

excel_export: Export multiple R data sets to Excel

Description

Exports a single data frame or a list of data frames to one or multiple excel sheets using the function write_xlsx frome the writexl package. This function can write multiple data frames (passed as a list) with a single command .It can write both .xls and .xlsx files.

Usage

excel_export(x,file,table_names=as.character(1:length(x)),...)

Arguments

x

Either a data frame or a list containing multiple data frame to be exported.

file

The name of the file we want to create.

table_names

A character or a vector character containing the names that will receive the sheet where the data frame is stored. If it is a vector, it must follow the same order as the data frames in x have. All names must be different from each others.

...

Value

No value is returned.

See Also

read_excel, read_excel

Examples

Run this code
# NOT RUN {
# }
# NOT RUN {
# x is a data.frame
file<-("mydata.xlsx")
a<- 1:10
b<-rep("b",times=10)
c<-rep(1:2,each=5)
x<-data.frame(a,b,c)
excel_export(x,file,table_names="mydata")
# x is a list
y<-list(x,x[2:3])
excel_export(y,file,table_names=c("mydata1","mydata2"))
# }

Run the code above in your browser using DataLab