xlsx.writeFile: Write a data.frame to an Excel workbook

Description Usage Arguments Author(s) References Examples

View source: R/r2excel.r

Description

Write a data.frame to an Excel workbook. This function is just a wrapper for the write.xlsx2 function from xlsx package.

Usage

1
2
xlsx.writeFile(data, file, sheetName = "Sheet1",
    col.names = TRUE, row.names = TRUE, append = FALSE, ...)

Arguments

data

a data.frame to write to the workbook.

file

the path to the output file.

sheetName

a character string with the sheet name

col.names

a logical value indicating if the column names of the data are to be written to the file.

row.names

a logical value indicating if the row names of the data are to be written to the file.

append

a logical value indicating if x should be appended to an existing file. If TRUE the file is read from disk.

...

Other arguments to write.xlsx2 from xlsx package

Author(s)

Alboukadel Kassambara <alboukadel.kassambara@gmail.com>

References

http://www.sthda.com

Examples

1
2
xlsx.writeFile(USArrests, file="USArrests.xlsx", sheetName="USArrests")
xlsx.openFile("USArrests.xlsx")

kassambara/r2excel documentation built on May 20, 2019, 7:40 a.m.