Description Usage Arguments Details Value Note Author(s) See Also Examples
Write a matrix
or data.frame
to a genuine Microsoft Excel XLSX file.
The first row is bold, italics, dashed underline. Columns are centred.
1 2 |
x |
either a |
xlsx |
the xlsx file to be created. |
verbose |
logical: print messages? |
row.names |
DIFFERENT TO |
col.names |
logical: If |
... |
additional arguments passed to |
Uses a perl module called Excel::Writer::XLSX
, by John McNamara,
a perl program called tab2xlsx
, based on a program of the same name also by
JM.
This R code borrows the structure from gdata
's excellent
read.xls
function.
none. writes an excel 'xlsx' file.
Installation
It's not that widely tested, but this package does include the necessary perl libraries to
write XLSX files. If you're struggling though, install the 'Excel::Writer::XLSX' Perl module
via CPAN or similar. For OSX users, this involves:
sudo perl -e shell -MCPAN
install Excel::Writer::XLSX
Mark Cowley, 2009-01-20. Updated 2016-04-14 to write XLSX files.
write.xls
write.table
read.delim
read.xls
1 2 3 4 | f <- tempfile(fileext=".xlsx")
write.xlsx(iris, f)
x <- list(A=iris[1:5, ], B=iris)
write.xlsx(x, f)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.